Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to alias SQL column - reserved word
Message
From
15/09/2008 15:47:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need to alias SQL column - reserved word
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01347748
Message ID:
01347748
Views:
54
An existing non changeable table has a column defined as DESC which is a reserved word. When I try to run the SQL UPDATE statement it fails.

I tried SET [desc] = "zzz"

Tried a macro no luck

CREATE CURSOR xx ( desc v(10))
INSERT INTO xx values('11111')
UPDATE xx SET desc = "zzz" --- this line does not work

How can I get around this?
Next
Reply
Map
View

Click here to load this message in the networking platform