U++ framework: U++ community news and announcements

Fri, 02 December 2011 00:20

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

		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:

] [

]

Current Time: Sun Sep 27 18:40:11 GMT+2 2026

Total time taken to generate the page: 0.01018 seconds