Subject Locking tables
Author Gustavo

First of all sorry for my english.

I am developping an application in Delphi 5 and I am using IBX. Sometimes my application does processing on big tables that last a lot of time and it needs to be sure that it can complete the operation when it commits the transaction. So I want to lock the tables involved before beginning the operation.

I tried starting a transaction with parameters 'consistency', 'nowait', 'lock_write=<TableName>' and 'protected' and it locks the table TableName. It works but I canĀ“t use it because I have to know which table to lock when I start the transaction and sometimes I start the transtaction and after that, depending on the result of other processing, I know what tables to lock.

Does anybody know how to lock a table when a transaction is already started?



[Non-text portions of this message have been removed]