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 » U++ SQL Begginer

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: U++ SQL Begginer [message #17374 is a reply to message #17365]

Sat, 09 August 2008 20:26

captainc is currently offline

captainc
Messages: 278
Registered: December 2006
Location: New Jersey, USA

Experienced Member

What you are looking at is where the Sql Upp classes become really powerful. As Mirek said, this is dynamic sql. The idea here is that you can assign parts of queries to variables and test them out individually, or put them together to form larger queries. You see the SqlBool object represents the section of a query where you would do a comparison. So you can say this:
Suppose NAME is a column in the tables NAME_TABLE1 and NAME_TABLE2:

// Build query:
SqlSet queryName1 = Select(NAME).From(NAME_TABLE1);
SqlBool nameIsSame = In(NAME,queryName1);
// Finish building and run query:
sql * Select(NAME).From(NAME_TABLE2).Where(nameIsSame);

SQL for this example would be:
SELECT name FROM name_table2 WHERE name IN (SELECT name FROM name_table1)

Granted you can do this more efficiently with joins and the such, but you should be able to get the idea.

Report message to a moderator

Send a private message to this user

[Message index]

		U++ SQL Begginer By: TeCNoYoTTa on Wed, 06 August 2008 14:15
		Re: U++ SQL Begginer By: captainc on Wed, 06 August 2008 16:41
		Re: U++ SQL Begginer By: TeCNoYoTTa on Wed, 06 August 2008 17:59
		Re: U++ SQL Begginer By: captainc on Wed, 06 August 2008 18:28
		Re: U++ SQL Begginer By: captainc on Wed, 06 August 2008 22:33
		Re: U++ SQL Begginer By: TeCNoYoTTa on Thu, 07 August 2008 13:03
		Re: U++ SQL Begginer By: captainc on Thu, 07 August 2008 15:23
		Re: U++ SQL Begginer By: TeCNoYoTTa on Sat, 09 August 2008 10:09
		Re: U++ SQL Begginer By: mirek on Sat, 09 August 2008 14:12
		Re: U++ SQL Begginer By: captainc on Sat, 09 August 2008 20:26
		Re: U++ SQL Begginer By: TeCNoYoTTa on Tue, 12 August 2008 10:31
		Re: U++ SQL Begginer By: TeCNoYoTTa on Tue, 12 August 2008 11:39
		Re: U++ SQL Begginer By: mirek on Tue, 12 August 2008 16:14
		Re: U++ SQL Begginer By: TeCNoYoTTa on Wed, 13 August 2008 11:18
		Re: U++ SQL Begginer By: captainc on Wed, 13 August 2008 22:08
		Re: U++ SQL Begginer By: TeCNoYoTTa on Thu, 14 August 2008 13:42
		Re: U++ SQL Begginer By: captainc on Thu, 14 August 2008 16:46
		Re: U++ SQL Begginer By: mirek on Thu, 21 August 2008 16:52
		Re: U++ SQL Begginer By: captainc on Thu, 21 August 2008 19:51
		Re: U++ SQL Begginer By: mirek on Thu, 21 August 2008 21:16
		Re: U++ SQL Begginer By: TeCNoYoTTa on Sun, 31 August 2008 10:47
		Re: U++ SQL Begginer By: captainc on Tue, 12 August 2008 13:19
		Re: U++ SQL Begginer By: TeCNoYoTTa on Tue, 12 August 2008 13:30

Previous Topic:	SQL_ProgreSQL example building problems
Next Topic:	SQL statment in constructor make program crash

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Fri Jul 18 08:18:44 CEST 2025

Total time taken to generate the page: 0.03378 seconds