Home » U++ Library support » U++ SQL » OleDB + parameters = problem
OleDB + parameters = problem [message #19782] |
Sat, 17 January 2009 18:16 |
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
|
|
|
|
|
OleDB + parameters = problem
By: Novo on Sat, 17 January 2009 18:16
|
|
|
Re: OleDB + parameters = problem
By: mirek on Mon, 19 January 2009 10:14
|
|
|
Re: OleDB + parameters = problem
By: Novo on Tue, 20 January 2009 23:34
|
|
|
Re: OleDB + parameters = problem
By: mirek on Wed, 21 January 2009 14:14
|
|
|
Re: OleDB + parameters = problem
By: mirek on Wed, 21 January 2009 14:22
|
|
|
Re: OleDB + parameters = problem
By: Novo on Fri, 23 January 2009 05:48
|
|
|
Re: OleDB + parameters = problem
By: Novo on Fri, 23 January 2009 06:03
|
|
|
Re: OleDB + parameters = problem
By: mirek on Fri, 23 January 2009 11:52
|
|
|
Re: OleDB + parameters = problem
By: mirek on Fri, 23 January 2009 11:59
|
|
|
Re: OleDB + parameters = problem
By: Novo on Sat, 24 January 2009 17:58
|
|
|
Re: OleDB + parameters = problem
By: mirek on Sat, 24 January 2009 20:19
|
|
|
Re: OleDB + parameters = problem
By: Novo on Sun, 25 January 2009 04:44
|
|
|
Re: OleDB + parameters = problem
By: Novo on Fri, 23 January 2009 05:55
|
|
|
Re: OleDB + parameters = problem
By: mirek on Fri, 23 January 2009 11:36
|
Goto Forum:
Current Time: Tue May 14 02:13:23 CEST 2024
Total time taken to generate the page: 0.02583 seconds
|