Tim

I have two situations:

First
TableList := TStringList.Create;
TableList.Add('MyTable);
Database.StartTransaction(TableList);
Table.Delete;
Database.Commit.

Second
Table.Delete;

In the first case only the table MyTable will be locked during transaction.
In the second, there is no transaction and then the engine will put a lock
on entire database ?

Eduardo

Eduardo

Only the table you're deleting from will be locked.

Roy Lambert [Team Elevate]

Roy,

<< Only the table you're deleting from will be locked. >>

And I would like to add - only *very* briefly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy and Tim

Thanks for the answers.

I don´t know where my head was when I asked this. This is so basic but
sometimes I fall just with small rocks.

Thanks anyway.

Eduardo