[unixODBC-support] question about catalog functions and bound parameters

Eric Sharkey sharkey at netrics.com
Mon Feb 14 18:53:51 GMT 2005


I have a generic question about bound parameters and catalog functions.

The ODBC docs on MSDN say:

  A variable remains bound to a parameter until a different variable
  is bound to the parameter, until all parameters are unbound by calling
  SQLFreeStmt with the SQL_RESET_PARAMS option, or until the statement
  is released.

My question is, what is supposed to happen if a statement handle
with bound parameters is used in a catalog function like SQLTables()?
Since, conceptually, all catalog functions are equivalent to executing
an unknown statement on a handle, should bound parameters be unbound
by the catalog function, or preserved?

Eric



More information about the unixODBC-support mailing list