Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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: 1358
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: Tue May 14 02:13:23 CEST 2024

Total time taken to generate the page: 0.02583 seconds