U++ framework: U++ TheIDE and Library: Releases and ChangeLogs

Sat, 28 June 2008 13:56

mirek
Messages: 14291
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 () ) {...}

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

		Some Sql addidtions By: unodgs on Thu, 26 June 2008 14:56
		Re: Some Sql addidtions By: zsolt on Thu, 26 June 2008 20:13
		Re: Some Sql addidtions By: tojocky on Fri, 27 June 2008 23:16
		Re: Some Sql addidtions By: zsolt on Sat, 28 June 2008 10:25
		Re: Some Sql addidtions By: cbpporter on Sat, 28 June 2008 12:18
		Re: Some Sql addidtions By: mirek on Sat, 28 June 2008 13:56
		Re: Some Sql addidtions By: tojocky on Sat, 28 June 2008 23:30
		Re: Some Sql addidtions By: bytefield on Sun, 29 June 2008 00:46
		Re: Some Sql addidtions By: mirek on Sun, 29 June 2008 18:15
		Re: Some Sql addidtions By: tojocky on Sun, 29 June 2008 21:03
		Re: Some Sql addidtions By: mirek on Mon, 30 June 2008 09:15
		Re: Some Sql addidtions By: mirek on Mon, 30 June 2008 09:36
		Re: Some Sql addidtions By: unodgs on Mon, 30 June 2008 12:05
		Re: Some Sql addidtions By: unodgs on Mon, 30 June 2008 21:04
		Re: Some Sql addidtions By: mirek on Mon, 30 June 2008 21:31

Previous Topic:	One more sql news
Next Topic:	Small new theide enhancement...

Goto Forum:

] [

]

Current Time: Fri May 15 07:05:49 GMT+2 2026

Total time taken to generate the page: 0.00532 seconds