>>>>TABLEUPDATE(.T.) lock the table
>>>
>>>Any way to unlock it? Say, tablerevert right after tableupdate? Or use tableupdate in a loop for getnextmodified (?) [but I thought it should be done internally]
>>
>>1. You cannot do a tablerevert within a transaction.
>>
>
>You're right. My mistake.
>
>>If you have append records,
>>remember to set to 0 the bit 0 of the SET TABLEVALIDATE TO value.
>
>Can you elaborate on this idea, please?
>
>Thanks.
I check ( for a handful of seconds ) this:
- use table with buffering=5
- update some records
- append some records
- begin trans
- tableupdate(all)
- IF BITTEST(SET("TableValidate"),0)
use table
ELSE
use table
ENDIF
then try:
SET TABLEVALIDATE TO 0