Thanks Helen.

Am I right in thinking that the performance benefit that accrues to using parameterized queries in some external programming language will also accrue to using procedures in Firebird (since these are also paramterized)?

Bernard

> He is talking about parameterised queries. With Firebird, you can make a
> statement like this:
>
> SELECT <COLUMN-LIST> FROM ATABLE
> ...WHATEVER WHATEVER
> WHERE ACOLUMN = ? (or :aColumn, or whatever is applicable in the dev.
> environment)
> AND BCOLUMN = ?
>
> (various syntaxes, depending on how the connectivity software implements
> params)