Subject | Re: [IBO] help me with IB_Script |
---|---|
Author | Sergio Zoccante |
Post date | 2009-06-25T15:22:34Z |
Hi, Al
Put a IB_Script component in the form, and set the IB_Connection and
IB_Transaction properties.
In the code:
try
IB_Script.SQL.Clear; // if needed
IB_Script.SQL.Add( <Here, a SQL statement1>); // or
IB_Script.SQL.Text := <Here, a SQL statement>;
IB_Script.SQL.Add( <Here, a SQL statement2>);
...
IB_Script.Execute;
IB_Script.IB_Transaction.Commit;
except
IB_Script.IB_Transaction.Rollback;
raise
end;
Ciao
Sergio
Put a IB_Script component in the form, and set the IB_Connection and
IB_Transaction properties.
In the code:
try
IB_Script.SQL.Clear; // if needed
IB_Script.SQL.Add( <Here, a SQL statement1>); // or
IB_Script.SQL.Text := <Here, a SQL statement>;
IB_Script.SQL.Add( <Here, a SQL statement2>);
...
IB_Script.Execute;
IB_Script.IB_Transaction.Commit;
except
IB_Script.IB_Transaction.Rollback;
raise
end;
Ciao
Sergio