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
