General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Using VFP5...
>>
>>I have a table (table1) set up with record buffering. I then create an updatable local view from it. I change a field
>>within the view and update as follows:
>>
>>View1 is made up of all records with table1.done<>.t.
>>
>>(for this example it finds one record so...)
>>
>>replace view1.done with .t.
>>=tableupdate()
>>
>>Now when I requery() looking for view1.done<>.t. (as before) the record I just changed still shows up as if the update never
>>happened. The update does happen when I exit the form. Can anyone clue me in to what I'm doing wrong?
>
>Both the view AND the table are buffered, so so need to issue 2 TABLEUPDATES, first the view, then the table. Better yet, don't buffer the table, then you just need 1 TABLEUPDATE, on the view.
What you suggested works. But for kicks I decided to try your "better yet" method. I turned off all buffering at the form property. I then
went to the DE and enabled optimistic row buffering on the view. It still exhibits the same behavior and I have to do the tableupdate
on both the view and table. Any more tips?
Previous
Next
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