I have a problem with databaselayer ODBC connecting to SQL Server. After a SQL DELETE statement execution, the application is hang. (the INSERT statement is okay)
Here is the snippet of codes (very simple SQL statement)
Code: Select all
wxString query = _("DELETE FROM employee WHERE name = ?");
PreparedStatement* statement = dbControl->PrepareStatement(query);
statement->SetParamString(1, employeeName);
statement->RunQuery();
dbLayer->CloseStatement(statement);
Code: Select all
dbLayer = NULL;
dbLayer = new OdbcDatabaseLayer();
((OdbcDatabaseLayer*)dbLayer)->Open("vman_dsn", wxEmptyString, wxEmptyString);
it is really weird problem because I've tried this statement using mysql database layer and it works fine.
anybody has a same problem with me?
thanks for your help