Hi, you can try to do this:
try
ADOConnection1.BeginTrans;
(Execute the INSERT statement)
ADOConnection1.CommitTrans;
except
if ADOConnection1.InTransaction then
ADOConnection1.RollbackTrans;
ShowMessage('Error');
end;
On Tue, Apr 21, 2009 at 02:33, appu kandan <[email protected]>wrote:
>
> Hi ,
>
> I am using ADO componet in delphi2006, I triyed to insert some data to
> table using INSERT query via ADOquery componet.
>
> I need to commit the insert data.
>
> to connect the database i am using ADO conncection component
>
> Thanks in Advance,
> Neela
>
>
> Own a website.Get an unlimited package.Pay next to nothing.*Go to
> http://in.business.yahoo.com/
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> -----------------------------------------------------
> Home page: http://groups.yahoo.com/group/delphi-en/
> To unsubscribe: [email protected]! Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
