Datasource - Filter

  • Thread starter Thread starter A. Peters
  • Start date Start date
A

A. Peters

Hello!
If I use a Filter on a Datasource, does he made a new Query with the
constraint of my definend WHERE clause or does it retrieve all Data and
then filter the content? If that isnt the right way, how can i add a
WHERE clause? All docu that I found speak about alle Data from a
Datasource or Table.

Regards
Alex
 
I think it will filter the full data it has. If you want to dynamically
change a database where clause then you need to generate your SQL on the fly.
Be sure however to parameterise the query to stop SQL injection errors.
 
Ciaran said:
I think it will filter the full data it has. If you want to dynamically
change a database where clause then you need to generate your SQL on the fly.
Be sure however to parameterise the query to stop SQL injection errors.
Click to expand...
Thanks!
 
Back
Top