Override BindParameters when you need to bind parameters before calling CDatabase::ExecuteSQL.
virtual void BindParameters( HSTMT hstmt );
- The ODBC statement handle for which you want to bind parameters.
This approach is useful when you do not need the result set from a stored procedure.
In your override, call SQLBindParameters and related ODBC functions to bind the parameters. MFC calls your override before your call to ExecuteSQL. You do not need to call SQLPrepare; ExecuteSQL calls SQLExecDirect and destroys the hstmt, which is used only once.