Usually you can enclose the reserved word in a quote or brackets [ ] and it will go through....
>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?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"