Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How Code remote view to SQL table that's a reserved word
Message
From
07/06/2005 14:47:45
Ernie Veniegas
Micro System Solutions, Inc.
Calistoga, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How Code remote view to SQL table that's a reserved word
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01021057
Message ID:
01021057
Views:
78
How do you code a remoteview to a SQL table that's a reserved word? In my example, there is a table in my SQL database named "transaction" another one named "order". VFP's remote view designer can't seem to handle these table names. I tried to do it outside of the designer with straight code but even brackets don't help. Eg. [transaction] or [order]

How is this supposed to be done?
Ernie Veniegas
Micro System Solutions
... sensible software by design
Next
Reply
Map
View

Click here to load this message in the networking platform