>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?
Below works with your test cursor, you'd have to try it in your real app:
UPDATE xx SET xx.desc = "zzz"
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up