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?
Best Answer
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
At first sight it looks OK. What do you mean by "fails to filter"? Do you get everything or nothing at all?
+26- 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