Toad World® Forums

ODBC positionable parameters.?

I am trying to bind variables in an query for a ODBC connection. The documentation I found says:

http://dev.toadfordataanalyst.com/webhelp/Content/Editor/Set_Bind_Variables.htm

  • For ODBC connections, you must use positionable parameters. Named parameters are not supported.
    I do not know what positionable parameters mean.

You could use ‘?’ for binding a variable for a ODBC connection. This is known as positional parameters since if you define two ‘?’ then it would match first one to first position parameter and second to second parameter. You can use :ColumnName for binding a named parameter in other cases.

P.S. I think we later did add named params for ODBC. So go ahead and try those.

select * from table

where col1 = :a

and col2 = :b