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 #19813 is a reply to message #19812] Fri, 23 January 2009 11:59 Go to previous messageGo to previous message
mirek is currently offline  mirek
Messages: 14261
Registered: November 2005
Ultimate Member
Anyway, it seems like DDL does not have such bad effect on precompiled statements after all:

void Test()
{
	Sql sql;
	sql * Select(ID).From(SUBJECT);
	Vector<int> id;
	while(sql.Fetch())
		id.Add(sql[0]);
	sql.SetStatement("select TEXT from SUBJECT_ATTR where ATTR = ? and SUBJECT_ID = ?");
	for(int i = 0; i < id.GetCount(); i++) {
		sql.Run("NAME", id[i]);
		if(sql.Fetch()) {
			DDUMP(sql[0]);
			SQL * Update(SUBJECT_ATTR)(ORG_ID, -1).Where(ID == id[i]);
		}
	}
}


Still has correct output...

I guess you can use the 'static' without too much worries.

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 16:38:35 CEST 2025

Total time taken to generate the page: 0.04197 seconds