Subject AW: [firebird-support] Best way to choose ALL or one item
Author Alexander Gräf
> -----Ursprüngliche Nachricht-----
> Von: ra8009 [mailto:ra8009@...]
> Gesendet: Dienstag, 28. Dezember 2004 22:07
> An: firebird-support@yahoogroups.com
> Betreff: [firebird-support] Best way to choose ALL or one item
>
> a) Build the SQL statement dynamically with the "where"
> clause or without as needed

No need to do anything else. You can (I dont know if your libraries support these) prepare the statements. Use one for the ALL-query (SELECT FROM Table), and another one with a parameter:

SELECT FROM Table WHERE Cat = :Cat;

Regards.