U++ framework
Do not panic. Ask here before giving up.

Home » U++ Library support » U++ SQL » OleDB + parameters = problem
OleDB + parameters = problem [message #19782] Sat, 17 January 2009 18:16 Go to previous message
Novo is currently offline  Novo
Messages: 1431
Registered: December 2006
Ultimate Contributor
Code:
void Test::remove_person(void)
{
    StringBuffer sql;
    Sql stmt(db_session);

    sql << "DELETE FROM person ";
    sql << "WHERE id = ?";

    try
    {
        stmt.SetStatement(sql);
        stmt.SetParam(0, sql_person(0));

	stmt.ExecuteX();
    }
    catch (const SqlExc& e)
    {
        sql_person.CancelRemove();
        Exclamation("[* " + DeQtfLf(e) + "]");
    }
}


Problem: Execute(OleDB): "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (Microsoft JET Database Engine)
SQL error: DELETE FROM person WHERE id = ?"


The same code was working fine when I wasn't using parameters, and was substituting value into the SQL statement.

Similar approach with parameters works fine with SQLITE database.

Am I missing something?


Regards,
Novo
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to use Sql * Update
Next Topic: Conditional jump or move depends on uninitialised value(s)
Goto Forum:
  


Current Time: Sun Apr 26 16:45:16 GMT+2 2026

Total time taken to generate the page: 0.00504 seconds