Skip to main content
  • EN

The where clause woks perfectly in a sql Script but when I use it for a Reader if fails to filter the dataset.

Am I missing some syntax?

Has anyone got examples of where clause syntax for a Reader?

At first sight it looks OK. What do you mean by "fails to filter"? Do you get everything or nothing at all?

I believe that if you use the SELECT, the WHERE is ignored.

But you can add the where clause in the SELECT parameter and leave the WHERE empty to get the right result.

Or you can leave the SELECT empty and then the WHERE will be added to the table reader as a filter.

I get everything in the database

Ahh erik_jan thats it !

Once I removed the select the where clause filtered the data.

I will try the where in the Select parameter as well

Thanks

Reply


Community Stats

30,159
Posts
114,480
Replies
37,806
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.