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 » Developing U++ » U++ TheIDE and Library: Releases and ChangeLogs » Some Sql addidtions
Re: Some Sql addidtions [message #16578 is a reply to message #16573] Sat, 28 June 2008 13:56 Go to previous messageGo to previous message
mirek is currently offline  mirek
Messages: 13980
Registered: November 2005
Ultimate Member
tojocky wrote on Fri, 27 June 2008 17:16

How about to write SQL queries as a simple text?
for example:
Quote:

Query *q;
q->SetText ( "SELECT SomeColumns FROM SomeTable WHERE SomeCondition = &SomeParameter GROUP BY SomeGoups HAVING SomeHavingCondition..." )
?
and after then we can set parameter value;
Quote:

q->SetParameter ( "SomeParameter", parameter_value );


after then we can do:

Quote:

QResult *q_result = q->Execute ();

QChoose q_chouse = q_result->Choose ();

while ( q_chouse->Next () ) {...}


or

Quote:

Array q_res = q->Execute ()->Unload ();


How about thi idea? I thing that this is more simple... and will be possible for sent to an server application only query text!


You can. That is U++'s "low-level".

E.g.

Sql sql;
sql.Execute("select foo from bar");
....

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
Read Message
Previous Topic: One more sql news
Next Topic: Small new theide enhancement...
Goto Forum:
  


Current Time: Wed May 15 09:32:18 CEST 2024

Total time taken to generate the page: 0.02418 seconds