U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » Community » U++ community news and announcements » Sql: New 'Of' 'syntax'

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

Return to the default flat view

Create a new topic

Submit Reply

Sql: New 'Of' 'syntax' [message #34611]

Fri, 02 December 2011 00:20

mirek is currently offline

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Recently I have found I am doing a lot of joins in SQL, which leats to pretty verbose 'syntax' to get columns in Select list:

Select(ID.Of(FOO), NAME.Of(FOO), SURNAME.Of(FOO),
       ID.Of(BAR), CODE.Of(BAR)).From(FOO).InnerJoin(BAR)...

after some thinking, I have introduced 'group synonym' for Of via function call, so now we can write:

Select(FOO(ID, NAME, SURNAME), BAR(ID, CODE)).From(FOO).InnerJoin(BAR)...

Report message to a moderator

Send a private message to this user

[Message index]

		Sql: New 'Of' 'syntax' By: mirek on Fri, 02 December 2011 00:20
		Re: Sql: New 'Of' 'syntax' By: unodgs on Fri, 02 December 2011 20:21
		Re: Sql: New 'Of' 'syntax' By: mirek on Sat, 03 December 2011 09:34

Previous Topic:	String & strlen optimization, force_inline in defs.h
Next Topic:	CParser::GetSpacePtr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Mon Apr 29 10:05:07 CEST 2024

Total time taken to generate the page: 0.02326 seconds