Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
The Missing Datefield???????
Versions des environnements
Application has a data entry form where adding or updating records are done within a private datasession. There are no controls that are bound to the table, but rather to a cursor. On the save option the following command is used
Insert into cTable (fld1, fld2, ..., datefieldname, ...) values (lcFld1, lcFld2,..., DATE(),...)
The insert trigger fires and does create a logging entry where the "datefieldname" value is correct. However the table's datefieldname value is empty.
This is not always happening, but enough to cause problems.
Question I have, does the trigger get called before or after the Insert happens in the Table?
Out of 20+ workstations, this is happening to just one computer and is giving me fits as to why or how to track it down.
I was assuming that the record is written to the table before the trigger is called. Is this correct?
thanks in advanvce
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