General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Alan,
If you have both the table and the view buffered you have to do a tableupdate() on both. The best way to do this is to buffer your view and leave the table itself unbuffered. Then the tableupate on the view will update the actual table.
HTH
Jeff
>Hello,
>I working with a Local View for the first time and I'm running into a problem with the update. After I issue my TableUpdate() the new record seem to be there. I can recall it and edit it. When I exit the application, then go back in, it's gone! I'm using VFP 6.0 SP3. I have both the table and the view set-up ad 3-Optimistic Row Buffering. I've tried it with 5-Optimistic Table Buffering also. It seems that the View creates a temporary file, but it is never written back to the table. I have a primary key and all of the fields are marked for update in the View designer.
>
>What am I doing wrong?
>TIA
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