Originally posted by: SystemAdmin

[UDOPS said:]

Has anyone tried, or had difficulty with parameterized querys using ODBC? I am using a DataDirect driver for a FileMaker Pro database, and it does not like the parameter example, such as:

DBRead(db, "SELECT afield FROM atable WHERE idfield = ?")(variable);

In my trials, the query works if I hard type the value into the query, but not with the parameter syntax. I also tried the Oracle syntax of :1 instead of ?
#DecisionOptimization
#OPLusingCPLEXOptimizer