range normally would mean all values. The solution is ALWAYS to use
the methods queryValue and queryRange (Class Global) to insert
values in a queryBuildRange from the X++.
You could make your programming a bit more secure by using table-
id's to address the datasources. The best practice way to find a
datasource is:
query.dataSourceTable(TableNum(<TableName>))
This construction will result in a compiler error if the name of the
table does not exist.
Your example would look like:
<DataSourceName>_DS.query().dataSourceTable(TableNum
(<TableName>)).addRange(FieldNum(<TableName>,<FieldName>)).value
(QueryValue(''));
Best regards,
Bj�rn M�ller Pedersen
Thy Data Center Development A/S
http://development.thydatacenter.dk/
--- In [EMAIL PROTECTED], "jp_axapta"
<[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I want to filter the records whose values are null in a perticular
> field using
>
> datasourcename_ds.query().datasourceno(1).addrange(fieldname).value
();
>
> I want to filter only those records whose field values is null.
>
> Thax in advance.
>
> Regards,
> jay
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
