Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
R/W View, but not updating base table
Message
 
To
30/05/2001 05:04:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00512548
Message ID:
00512796
Views:
7
Kevin,

Create your view in the view designer. On the the Update Criteria tab make sure "Send SQL Updates check box" is unchecked.

You can do this in code as view by using the following:

DBSetProp('VIEW1', 'View', 'SendUpdates', .F.)

>Hi
>
>Can I create a view that can be written to, but will not reflect any updates back to the base tables?
>
>Thanks
>Kev
>
>PS It DOES has to be a view, not a created cursor.
Previous
Reply
Map
View

Click here to load this message in the networking platform