BeforeUpdadeExecute

Joelson · Post by **Joelson** » Thu 09 Mar 2006 19:44

First,please forgive me with my poor english,because english is not my native language.

how to use BeforeUpdadeExecute with to set parameters?

Challenger · Post by **Challenger** » Fri 10 Mar 2006 12:47

You can write event handler for OnBeforeUpdadeExecute event and set all necessary parameters using Params variable. If you have any problems with using functionality feel free to contact us.

Guest · Post by **Guest** » Fri 10 Mar 2006 16:14

procedure TForm1.OraQuery1BeforeUpdateExecute(Sender: TDataSet;
StatementTypes: TStatementTypes; Params: TDAParams);
begin
OraQuery1????????????
end;

How to, to pass Params?

Challenger · Post by **Challenger** » Mon 13 Mar 2006 16:10

procedure TForm1.OraQuery1BeforeUpdateExecute(Sender: TDataSet;
StatementTypes: TStatementTypes; Params: TDAParams);
begin

end;

Params will contain all parameters that were used in UPDATE SQL statement. You can set any parameter by name using Params.ParamByName('Name') function or by index Params[Index].