Mytable: catching & displaying the SQL update

Mytable: catching & displaying the SQL update

Postby sean » Wed 24 Nov 2004 19:43

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
sean
 

Re: Mytable: catching & displaying the SQL update

Postby Ikar » Thu 25 Nov 2004 08:24

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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby sean » Fri 26 Nov 2004 11:26

But how can I access the DML command, is there a property to the table?
sean
 

Postby Ikar » Fri 26 Nov 2004 16:09

You really are unable to get text of DML in OnBeforePost. So you should use another event for processing.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components