Page 1 of 1

Mytable: catching & displaying the SQL update

Posted: Wed 24 Nov 2004 19:43
by sean
Hi,

I was wondering if its possible to catch the SQL UPDATE command sent to the server, when a post is done, and show it to the user first for confirmation? (I'd like to confirm changes)

Perhaps tying in code code on OnUpdateRecord()?

Thanks in advance,
Sean

Re: Mytable: catching & displaying the SQL update

Posted: Thu 25 Nov 2004 08:24
by Ikar
Suppose, it would be correct to process OnBeforePost event and formulate a question to the user not as SQL DML, but in more usual form.

Posted: Fri 26 Nov 2004 11:26
by sean
But how can I access the DML command, is there a property to the table?

Posted: Fri 26 Nov 2004 16:09
by Ikar
You really are unable to get text of DML in OnBeforePost. So you should use another event for processing.