>>In the following I am gettting a Syntax Error on the Update command. (I must be going blind.)
>>
>>What am I doing wrong?
>>
>>
>>CREATE CURSOR itest (name c(50), section C(50), value C(250))
>>INSERT INTO itest VALUES ('Test','Main','1')
>>Update iTest set Value="2" where Section="Main" and Name="Test"
>>>
>You have field named as keyword.
>Change Value to Value1 and you will have no problems.
Or just prefix Value with the alias (Actually I would argue that all fields should be prefixed with the alias):
Update iTest set iTest.Value="2" where iTest.Section="Main" and iTest.Name="Test"
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
