Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Yes: 10, Syntax error. No error unless that one field's value changes in the view.
>
>What is the name of the field it is changing? What is the value it is trying to set it to?
>
>An updatable view is simply a wrapper to basic SQL. When you update the values and issue a Tableupdate, the engine goes through and based on the update settings of the view, builds an UPDATE SQL statement to handle the actual update.
>
>If the name of the field is a reserved word, you may have problems. This is normally the case when using remote views. If there are embedded character delimeters, you may get an error.
Hmmmm... I thought it might be the first one (it was called DESC), but that wasn't it as I changed the name throughout and it still failed. The second one though... This is a description field and contains a variety of freeform text - are you asking if the field value itself contains some characters that might cause problems in the update? Is there a list somewhere of bad characters BTW, that's a pretty good straight line for comedians out there. :)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement