Mytable: catching & displaying the SQL update

[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

[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.

[sean]

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

[Ikar]

You really are unable to get text of DML in OnBeforePost. So you should use another event for processing.