Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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. :)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only