Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field naming conventions in SQL
Message
From
12/12/2000 17:06:23
 
 
To
11/12/2000 11:43:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00450333
Message ID:
00452582
Views:
26
Hi Doug,

>First, you can get around the problem of using reserved words by putting quotes around them; for example, SELECT "PERCENT" FROM SOMETABLE.

Does this work for all back-ends ?

Also, you would have to put quotes around every field name in order to be safe - PERCENT was not a reserved word in SQL Server 6.5, but it was one in SQL Server 7.0 and above.

Code you write now could easily be broken when the user upgrades his copy of the back-end.

Best.

Matt.
Previous
Reply
Map
View

Click here to load this message in the networking platform