Home » Community » U++ community news and announcements » Sql: New 'Of' 'syntax'
Sql: New 'Of' 'syntax' [message #34611] |
Fri, 02 December 2011 00:20 |
|
mirek
Messages: 13980 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)...
|
|
|
Goto Forum:
Current Time: Thu May 16 19:42:42 CEST 2024
Total time taken to generate the page: 0.02564 seconds
|