I guess you need that :
SysQuery::valueNotEmptyString();
Steeve...
--- In development-axapta@yahoogroups.com, "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]
>
