Subject SV: [firebird-support] ODBC queries with parameters failing
Author Poul Dige
> Fra: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] På vegne af Kurt Fitzner
> Sendt: 27. februar 2013 19:19
> Til: firebird-support@yahoogroups.com
> Emne: [firebird-support] ODBC queries with parameters failing
>
> Hello,
>
> I am trying to use Firebird as a back end for LibreOffice Base. I have
> downloaded the embedded client and attached it to the ODBC driver, and it
> seems to work except in the case of complex queries that use ODBC
> parameter markers (question marks) for parameter replacement in SELECT
> statements.

I don't know if this will solve your problem but usually you use variable names as parameters, e.g.

select col1 from table 1 where col1 = :myparameter

Best regards
Poul