Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable view
Message
From
16/10/1997 15:21:39
 
 
To
16/10/1997 15:15:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00054939
Message ID:
00054945
Views:
29
>I use parameterized views in many of my forms but only just recently was confronted with the need to have one of them updateable. The form is a one to many form with parent information on the first page of a pageframe and a grid with child information on the second. In page2's page.activate, I set the view's paramter, and requery, and then refresh the grid. This works fine. What doesnt work is the updateable part. (the fields have been specified as updateable in the view designer). In the second page's deactivate event is a TABLEUPDATE(). When after updatinga field and switching to the first page, and then switching back, I get an error on the REQUERY line of page2.activate:"Table buffer for alias 'myviewname' contains uncommitted changes" So I changed the code in page2.deactivate to read tableupdate(1, .T. 'myviewname'). No difference. So I tried
>SELECT myviewname
>TABLEUPDATE()
>
>No change. How do I commit changes to the view?
>
>Thanks

Excuse me for silly question. Did you check Send Sql Updates in View Designer?
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform