Cetin, you're fantastic.
This didn't fix the problem, below - I had to put the GATHER MEMVAR in a DO WHILE EMPTY loop, but today I had a problem with one of my applications which is currently used in 3 locations with the TABLEUPDATE(.T.) failing on just one record on particular table.

I remembered this replay you sent me and changed to TABLEUPDATE(0,.T.) and everything is fine now. Now I am madly changing all TABLEUPDATE'S in the application. It's amazing, I have been using TABLEUPDATE(.T.), thinking I was forcing the update, since VFP5 first came out and this is the first time I have encountered a problem.

Thanks.
Doug Johnston



>>Hi,
>>
>>I am using paramaterised views and for one quick file update I do...
>>

>>SELECT view 1
>>SCATTER MEMVAR MEMO
>>SELECT view 2
>>APPEND BLANK
>>GATHER MEMVAR
>>IF TABLEUPDATE(.T.) = .F.
>>   =TABLEREVERT(.F.)
>>ENDIF
>>

>>...this works fine 75% of the time, but on odd occasions the GATHER MEMVAR doesn't update the view. A new blank record is created.
>>
>>This has happened on two computers on a 4 computer network and my own development machine.
>>
>>Has anyone come across such a problem.
>>
>>Regards
>>Doug Johnston
>
>Doug,
>You might be scattering an empty record (at eof() ?).
>You're doing a tableupdate at table level but tablerevert at row level. If it's another record offending in view, tableupdate would fail and be on that row. You'd be reverting that row not the append blank row.
>
>Cetin