Home » U++ Library support » U++ SQL » OleDB + parameters = problem
Re: OleDB + parameters = problem [message #19786 is a reply to message #19782] |
Mon, 19 January 2009 10:14   |
 |
mirek
Messages: 14261 Registered: November 2005
|
Ultimate Member |
|
|
Well, I have to admit I am not using parameters mode too much recently; usually it buys you nothing.
Anyway, out of curiosity, I have tried in my current application to replace some SqlExp with explicit params:
#if 1
sql.SetParam(0, cat.GetKey());
sql.Execute("select ID, TEXT from ITEM_TYPE where ITEM_CATEGORY_ID = ? order by TEXT");
#else
SqlBool wh;
if(!IsNull(cat.GetKey()))
wh = ITEM_CATEGORY_ID == cat.GetKey();
sql * Select(ID, TEXT).From(ITEM_TYPE).Where(wh).OrderBy(TEXT);
#endif
In any case, maybe you can try inverse conversion - from SetParam to SqlExp....
BTW, StringBuffer buys you nothing here over plain String and you can simplify your life intensely by using global SQL (as long as you have only single main rdbms):
void Test::remove_person(void)
{
try
{
SQL.SetParam(0, sql_person(0));
SQL.ExecuteX("DELETE FROM person WHERE id = ?");
}
catch (const SqlExc& e)
{
sql_person.CancelRemove();
Exclamation("[* " + DeQtfLf(e) + "]");
}
}
Mirek
|
|
|
 |
|
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: Wed Jun 25 14:21:05 CEST 2025
Total time taken to generate the page: 0.04310 seconds
|