U++ forum: Welcome to the forum

Search on this site

Search in forums

Thu, 26 June 2008 14:56

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

Recently I made possible to write select in select fields list:

SQL * ::Select(
   ID, 
   NAME, 
   ::Select(NAME, AGE).From(PARENTS).Where(KID_ID == ID),
   PHONE
).From(KIDS)

..and conditions

SQL * ::Select(
  X == Y,
  NUMBER < 100,
).From(TABLE)

SqlNvl has now As() method so it's possible to write:

SQL * ::Select(
   (QUANTITY * PRICE).As(FINAL_PRICE)
   (NAME | SURNAME).As(FULL_NAME)
).From(PRICES)

It's also possible to write cases:

SQL * ::Select(
  ID,
  Case(AGE < 5, "Baby")
      (Between(AGE, 5, 10), "Kid")
      ("Young man"),
  NAME
.From(PERSONS)

		Some Sql addidtions By: unodgs on Thu, 26 June 2008 14:56
		Re: Some Sql addidtions By: zsolt on Thu, 26 June 2008 20:13
		Re: Some Sql addidtions By: tojocky on Fri, 27 June 2008 23:16
		Re: Some Sql addidtions By: zsolt on Sat, 28 June 2008 10:25
		Re: Some Sql addidtions By: cbpporter on Sat, 28 June 2008 12:18
		Re: Some Sql addidtions By: mirek on Sat, 28 June 2008 13:56
		Re: Some Sql addidtions By: tojocky on Sat, 28 June 2008 23:30
		Re: Some Sql addidtions By: bytefield on Sun, 29 June 2008 00:46
		Re: Some Sql addidtions By: mirek on Sun, 29 June 2008 18:15
		Re: Some Sql addidtions By: tojocky on Sun, 29 June 2008 21:03
		Re: Some Sql addidtions By: mirek on Mon, 30 June 2008 09:15
		Re: Some Sql addidtions By: mirek on Mon, 30 June 2008 09:36
		Re: Some Sql addidtions By: unodgs on Mon, 30 June 2008 12:05
		Re: Some Sql addidtions By: unodgs on Mon, 30 June 2008 21:04
		Re: Some Sql addidtions By: mirek on Mon, 30 June 2008 21:31

Previous Topic:	One more sql news
Next Topic:	Small new theide enhancement...

Goto Forum:

] [

]

Current Time: Mon Apr 29 04:14:50 CEST 2024

Total time taken to generate the page: 0.01903 seconds