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 » [sql] Select embeded in join

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: [sql] Select embeded in join [message #22840 is a reply to message #22815]

Fri, 21 August 2009 14:30

mirek is currently offline

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Zbych wrote on Tue, 18 August 2009 17:08

Hi,

I need to embed select inside left join. I've found AsValue function, but I could not find anything that converts SqlSelect to SqlId, so I added this:

SqlId    AsTable(SqlId table) const               { return SqlId(String("(") << text << ")").As(table); }

to class SqlSelect.

Maybe it doesn't look to good, but it works.

Would it be possible to use other type as return value?

The problem is that the way SqlId works, all 'ids' are stored *permanently* (and then only integer indexes to the permanent Index are used). Means, using SqlId here could be considered a sort of leak...

Mirek

Report message to a moderator

Send a private message to this user

[Message index]

		[sql] Select embeded in join By: Zbych on Tue, 18 August 2009 23:08
		Re: [sql] Select embeded in join By: Zbych on Wed, 19 August 2009 16:32
		Re: [sql] Select embeded in join By: mirek on Mon, 24 August 2009 10:58
		Re: [sql] Select embeded in join By: mirek on Mon, 24 August 2009 15:45
		Re: [sql] Select embeded in join By: Zbych on Fri, 28 August 2009 12:06
		Re: [sql] Select embeded in join By: mirek on Sat, 29 August 2009 00:18
		Re: [sql] Select embeded in join By: mirek on Fri, 21 August 2009 14:30
		Re: [sql] Select embeded in join By: Zbych on Fri, 21 August 2009 15:59

Previous Topic:	Possible SqlOption Problem [Solved]
Next Topic:	Postgresql - execpt vs minus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat May 04 06:17:28 CEST 2024

Total time taken to generate the page: 0.03187 seconds