Information générale
Titre:
Insert records in views
We use a stored produre to generate a unique number for Id-fields. The 'default value' of those fields calls the procedure. This usely works fine.
Now we work with a view which update a certain table. When we perform an 'Insert' on the view a record is inserted in the table also. The table-record has a unique Id genated by the stored procedure but the record in the view is not updated and the Id is 0. I can not perform a 'Requery' because we are in the middle of a transaction.
Does anybody know a good solution for this problem.
Marco
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