>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
If you dont have SET DELETED ON before you requery your view (or initially get it) then I think deleted records will come over. So if you get your data into a view and delete a record, save the view, then rwquery and set deleted is off then you will get back the deleted record, but with set deleted on you should not. Try this out please and check my assumptions. HTH
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope