>Hi Aleksey,
>
>I would like to receive a confirmation if the behavior discussed in the Re: Transaction behavior Thread #1075467 is by design and then the Help is wrong or the behavior is wrong and the Help is right. In the code we're doing inserts into multiple tables with buffered mode 5. Then we're saving data within transaction. If we're trying to open the tables in other VFP session on the same PC we're getting "File is in Use" error message.
>
>Thanks in advance.

Hi Naomi,

VFP doesn't release any locks for transactable files until transaction is closed. If TABLEUPDATE locks the table or table's header then the lock will be held at least until the transaction is closed and an attempt to open this table from another client may fail, depending on the current SET TABLEVALIDATE setting for that client. There should be no problem to open the table if SET TABLEVALIDATE setting for the other client includes flag 4.

Naomi, if you think that this doesn't explain behavior of your app, you should provide complete repro code for the issue (this doesn't mean that you have to copy and paste code from your project or use tables and data from your project or use many tables when the problem can be reproduced with one).

Thanks,
Aleksey.