>More simplier: user do 'append blank' edit that record and issue 'tableupdate()' from now on sometimes
>facts go wrong, instead of record appended to the file it get another modified.
>-table are optimistic row buffer.
>-nothing moves record pointer between append and update
>-in audit records wich is updated by triggers on working table for this appended record is recorded
>update-old values from one existing record and update-new values edited by user
>Question is how for a appended record in buffer I get update trigger executed instead of insert trigger ?
Can you post a simple code sample and instructions that shows this happening? I've been able to reproduce it in the past, but last time I tried to make it happen, I couldn't get anywhere near the right code.