Some ADO requests are commited, some not???

[davidchardonnet]

Hello,

I just started a transaction and I wonder what is so strange... Some of the UPDATE statements don't work when i use them with the ADOQuery, but they work fine with the command line of the SQL Server 7 I use. There is no error message displayed. I really don't know what the problem can be.

I start with:

Form1.GlobalConnection.BeginTrans;
try
//---------------------------------------
// Here I make many requests with ADOQuery7
// I change its SQL property, and make
// SELECT,UPDATE,INSERT statements
// just for 1 transaction
//---------------------------------------
Form1.GlobalConnection.CommitTrans;
except
Form1.GlobalConnection.RollbackTrans;
raise;
end;

Do you know what it can be?

Thank you

David