General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need to alias SQL column - reserved word
Environment versions
Network:
Windows 2008 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only