Information générale
Titre:
Trouble updating a view
I have created a view in code using 'Create SQL View' that includes a master table and 4 other child tables. The child tables are all left outer joined to the master table (Master table is on the left). I've allowed the fields in the master table to be updated using DBSetProp(). The problem arises after a new record is appended to the view. When the record pointer moves in the view the following error occures:
'Cannot insert an empty row from a view into its base table(s)'
Before the record pointer moves there is data in one of the fields in the master table. But it prevents the appended record from be updated to the base table. Also, I do not want to add a record to any of the child tables when the a record is appended to the master table.
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