Hi All,

Is there a way to select a row from a data source with condition of an empty field ?
In SQL, we can say select aTable where aTable.field == "";
But I couldn't do this in form data source.

In the form class declaration, I declare a QueryBuildRange object,
QueryBuildRange     range;

then in the data source's init method I set the query :

range = this.query().dataSourceNo(1).addRange(fieldNum(aTable,aField));

Then, somewhere in the form, I put code like this

range.value(someValue);
aTable_ds.executeQuery();

Those code work only when I set someValue to any not null value. But if I set someValue to empty string,
the filtering do not work. It retrieve all rows of that table.

Anybody can help me to find some solution ?

Thank you in advance.







Yahoo! Groups Links

<<winmail.dat>>

Reply via email to