Hi VG,
you can use sysquery::valueNotEmptyString() as the value of the range.
newQueryRun.query().....value(sysquery::valueNotEmptyString());
Regards,
Kris
V G <[EMAIL PROTECTED]> wrote:
Hi
I want to add a range in a query where the value of the field must not be
empty.
like in this example we added a range where salesstatus cannot be canceled
or invoiced.
newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable,
salesStatus)).value('!Canceled, !Invoiced');
similarly is there a way tto define a range so that the only records which
have some value in there project field are selected.
Thanks in advance
VG
[Non-text portions of this message have been removed]
---------------------------------
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
[Non-text portions of this message have been removed]
