>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
Are you doing TABLEUPDATE() on your main table?
I'm not 100% certain, but AFAIK trigger fires after main table update is done. However, if you have a failure in the trigger the main changes are not supposed to be saved.
If it's not broken, fix it until it is.
My Blog