Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making updateable local view, vfp 8
Message
 
To
15/12/2006 13:56:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01178095
Message ID:
01178109
Views:
20
>I created a local, updateable View using the Query wizard/designer. No joining, just 1 table as the source. Ran GenDBC and grabbed the code. Deleted the View. Modified the SELECT from GenDBC so that the View had some "computed fields" (e.g., SPACE (10) AS FooBar). Made no other changes to the GenDBC code. Ran the modified GenDBC code to create the View I really wanted. Seemed to work (the grid using the View looked pretty, worked with my code in the Form and the Grid). Unfortunately, the original table is not getting the new values from the View.
>
>The View has optimistic buffering. I did a TABLEUPDATE on the View. Both the View and the original table are in the DataEnvironment.
>
>Any thoughts?
>
>Tim

The original table should not be buffered, but if it is, you need an extra TABLEUPDATE for it.
Doru
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform