Hi Alex, long time not seen, greetings!
> > 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. Well... 1) If something goes wrong during database access, method InsertEvent.processEvent() will abort with an SQLException and Post-Interceptors will not be called. 2) It is true that you do not get field values within postInterceptor. However, you get the same instance of request, you might put some values into it (within preInterceptor) using setAttribute() and get them back again within postInterceptor using getAttribute(). Or not? ... Regards Dirk ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
