Jim,
The whole code block is inside a FOR loop, so the ROLLBACK does not get hit unless m.lSuccess = .F. (BTW, this is from VFP sample code, I probabably wouldn't have written it that way!)
- Harry

>Harry,
>
>What is that ROLLBACK doing after the ENDIF???
>
>Good luck,
>
>Jim N
>
>>By moving the pointer, I mean it does the update, but after the update has finished, the record position is another record. For example, I APPEND BLANK a record (let's say record # 8). The TABLEUPDATE hits #8, but is then on record #7 after that. It is intermittent, and happens inside a form that has the parent table and a number of other tables in the DE. Here's the section w/the TABLEUPDATE:
>>
>>BEGIN TRANSACTION
>>* Try to update all records in selected table
>>m.lSuccess = TableUpdate(.T.,.F.) &&successful update
>>IF m.lSuccess
>> END TRANSACTION
>> LOOP
>>ENDIF
>>ROLLBACK
>>
>>Thanks...