U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Is this correct?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: Is this correct? [message #8586 is a reply to message #8581]

Tue, 20 March 2007 10:12

mirek is currently offline

mirek
Messages: 14267
Registered: November 2005

Ultimate Member

MikeyV wrote on Mon, 19 March 2007 20:44

Quote:

Did you SQL.Fetch()?

No, I wasn't sure how. Is it like:

SQL * Select(SqlSum(PS)).From(AreaMission);
while(SQL.Fetch())
    x += SQL[0];

Yes

Smile

Sure, we still owe everybody the nice SQL tutorial...

BTW, while above code is OK, I do not recommend using SQL with Fetch - it is global variable and way too often you can make a mistake here (by issuing another query on the same SQL).

So if you are going to Fetch, rather use:

Sql sql;
sql * Select(...
while(sql.Fetch())

Mirek

Report message to a moderator

Send a private message to this user

[Message index]

		Is this correct? By: MikeyV on Mon, 19 March 2007 21:00
		Re: Is this correct? By: mirek on Tue, 20 March 2007 00:22
		Re: Is this correct? By: unodgs on Tue, 20 March 2007 08:26
		Re: Is this correct? By: MikeyV on Tue, 20 March 2007 01:44
		Re: Is this correct? By: mirek on Tue, 20 March 2007 10:12

Previous Topic:	An improvement to SqlArray::PerformInsert
Next Topic:	Sqlite3 Forcing creating a database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Aug 24 15:37:48 CEST 2025

Total time taken to generate the page: 0.03744 seconds