Doru,
Thank You. That was it!! In addition to the view being in the data enviroment, I also had the source table in the data enviroment with both of them set to buffer. I've spent hours on this problem and was about to give up when your reply came through, You are a life saver. Thanks again. and thanks to the others for there help.
>If the view is buffered
and the source table of the view is buffered too, then the tableupdate() on the view will send the updates to the table buffer, not to the table. The table will then be updated, automatically, when the record pointer in it moves.
>
>>I'm sure there is an easy solution to this, but I need your help. When I delete a record from a local view, I do a tableupdate() and a requery() but the record still shows as if it were there. If I try to delete it again, I get an "Update Error". If I exit the application then look again, it is gone. I tried the update with the force flag, same thing. What is the proper way to do this? I am using optimistic row buffering.
>>
>>TIA
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108