It sounds as if you are doing something like this:
Append blank
[fill in form]
[check for errors]
replace x with m.x, ...
If this is so, I would recommend that you have the user fill in the form using memory variables of the same name as the database fields. Do all of your validations against these fields. When you are truly ready to put the record in the database, peroform an INSERT INTO [databasename] FROM MEMVAR. This is more efficient, gets rid of the kinds of problems you are discussing, and ensures that there are no orphan records.
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