Subject Re: [IBO] Re: Accessing 'previous' values during posting/commiting
Author Daniel Rail
Hi,

Do you still have the code in AfterCommit? If so, try it in
BeforeCommit. If it's still the same, it might be possible that
OldValues saved the new values when the TIB_Query.Post is performed.

One way to find out would be to show the values stored in OldValues in
the BeforePost event of TIB_Query. If you get the old values at that
point, then it might be to write the old values to a temporary file,
then merge that temporary file into the actual target file in the
AfterCommit event of TIB_Transaction. But, don't forget to delete the
temporary file after the merge or if there's a ROLLBACK.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)