Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL update fails when field name is keyword
Message
From
27/07/1998 14:10:39
 
 
To
27/07/1998 14:05:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00121702
Message ID:
00121714
Views:
18
The ugly workaround is to make 'Desc' non-updatable in View, and change data directly in table from appropriate textbox.InteractiveChange or from cmdSave.click (depending on interface functionality).

>Thanks, but my issue is that the field has been around for 5/6 years, and renaming the field would be undesirable at this point. I would much rather have a work-around.
>
>Things I've tried:
>* changing the view to use an "AS cDesc" clause
>* changing the "update" settings on the update tab
>
>Nothing has worked so far.
>
>Bob
>
>>Look at the online help at 'Reserved Words'. These should
>>not be used as field or variable names.
>>-myron kirby-
>>=========================
>>>We have an old table that has a field named "desc" that worked perfectly. Now we have found that TABLEUPDATE() fails when we have a view that includes this field.
>>>
>>>How can we get the TABLEUPDATE to succeed without renaming our field?
>>>
>>>
>>>Bob
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform