Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL update fails when field name is keyword
Message
De
27/07/1998 14:10:39
 
 
À
27/07/1998 14:05:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00121702
Message ID:
00121714
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform