I solved a similiar problem. I needed to insert a record into
a LDAP directory after a successful insert into ORACLE. I got it to
work by storing all the fieldvalues in individual session
attributes.
I then retrieve the session attributes in
the the postInsert() method and reinsert into the LDAP directory ( or audit
table, in your case ).
Hope it
Helps,
Edward
S.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Colic, Alex
Sent: Wednesday, October 09, 2002 8:25 AM
To: '[EMAIL PROTECTED]'
Subject: [dbforms] postInsert Interceptor and field values question.Hi,
I am moving an app based on an IBM cloudscape database to mysql. I had about 4 triggers being used in the cloudscape database. On insert records were written into audit tables. Since mysql does not support triggers I have to manually write these audit records.
I can see that when a user tries to insert a record via dbforms the values being inserted can be retrieved via the pre insert interceptor but what about the post interceptors. I only want the audit record to be created if they insert was successful.
Any suggestions on how to get around this problem?
Thanks
Alex
