Hi,
i try to achieve below sql select with x++. i have two defirent fields in where clause:
SELECT *
FROM TableName
WHERE TableName.date1<= @date or TableName.Date2<= @date
i tried this one but the range not works:
qbr = qbds.addrange(fieldnum(TableName,Date1));
qbr = qbds.addrange(fieldnum(TableName,date2));
qbr.value(strfmt('((%1.%2 <= %4) || (%1.%3 <= %4))',
qbds.name(),//%1
fieldstr(TableName, date1),//%2
fieldstr(TableName, date2), //%3
ToDate.dateValue())); //%4
qbr.status(RangeStatus::Hidden);
infolog :
Any help in this issue.
Regards