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...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only