 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
John MacDonald
Guest
|
 Posted: Fri Dec 29, 2006 10:08 pm Post subject: Local SQL "DESC" keyword - workaround |
 |
|
Hello folks:
I am using the Local SQL that came with my builder 5 ent.
One of the main databases has a field names DESC - this is also a keyword. I
would like to use the field name in a Order By clause.
Does anyone have a workaround?
JMAC out |
|
| Back to top |
|
 |
Vassiliev V. V.
Guest
|
| Posted: Fri Dec 29, 2006 11:19 pm Post subject: Re: Local SQL "DESC" keyword - workaround |
|
|
Quote column name. Depending on DBMS one of following may work:
[DESC]
"DESC"
`DESC`
in last variant ` is not single quote.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"John MacDonald" <jmac (AT) itmeasures (DOT) com> сообщил/сообщила в новостях
следующее: news:45953ca4$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Hello folks:
I am using the Local SQL that came with my builder 5 ent.
One of the main databases has a field names DESC - this is also a keyword.
I
would like to use the field name in a Order By clause.
Does anyone have a workaround?
JMAC out
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
