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
Re: OleDB + parameters = problem [message #19786 is a reply to message #19782] Mon, 19 January 2009 10:14 Go to previous messageGo to previous message
mirek is currently offline  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
 
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: Wed Jun 25 14:03:33 CEST 2025

Total time taken to generate the page: 0.04351 seconds