Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating local views
Message
From
13/07/1999 21:11:55
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00237594
Message ID:
00241103
Views:
18
Hi, Jeremiah-
Are you using version 3.0? I don't know if that was true for 3.0, it's certainly not true for 5.0.

If you are using 3.0 and want to test it for yourself it is easy enough to do.

1. Create a local view
2. Set a key field
3. don't check Send SQL updates
4. Clear all (to close all tables and views)
5. USE your view
6. CURSORSETPROP to optimistic table buffering (5)
7. REPLACE ALL of some field
8. ?TABLEUPDATE() should be .T., if you've haven't violated any unrelated rules :)
9. CLEAR ALL
10. Use the base table (not the view), and browse and check your field for the changes (they shouldn't have changed)

Now do all the above again except in #3, do check Send SQL Updates

Good luck.

>Hi,
>
>Sorry it took me so long to reply...
>It might have been my misunderstanding, but on page 382 of "Using Visual Foxpro 3 for Windows", there is a note that says,
>
>"Visual FoxPro can create an updateable view of local data, but the data is only buffered. The features on the last page of the View Designer [i.e., Send SQL updates] refer to updateable remote data views."
>
>>What book is it that says that? Thanks.
>
>>>One of the Foxpro books I have explicitly states that the "Send SQL updates" >>feature of the view designer only worked with remote views.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform