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?
Solved
Reader where clause
+1Best answer by erik_jan
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.
At first sight it looks OK. What do you mean by "fails to filter"? Do you get everything or nothing at all?
+17- Contributor
- Best Answer
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.
+1Ahh 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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.