Sunday, 1 July 2012

View or function 'XXX' is not updatable because the modification affects multiple base tables

You get this error when running your application:
Unable to create record. View or function 'XXX' is not updatable because the modification affects multiple base tables.
This message is generated by the underlying database and displayed by your generated application.  Most likely, one or more fields in the database tables underlying the database view are read-only and cannot be updated.  The referenced database view must be updatable.
When Iron Speed Designer updates a view, it requires all fields in all the tables involved in the view to be updatable. You will receive the above error message if even one field (belonging to the tables involved in the view) is not updatable.

No comments:

Post a Comment