Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pview, combo and grid
Message
 
To
01/05/2000 15:19:27
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00364856
Message ID:
00364948
Views:
15
Michael,
Any view (parameterized or not) will update its underlying table(s) if set up correctly. Open the view designer and go to the Update Criteria tab. Be sure you've checked the "Send SQL Updates" box (this is the usual problem when views won't update - it defaults to UNchecked). Then mark the fields you want to update, and mark the key field.

When this is done, a view will save to the underlying tables by calling TableUpdate(). If your underlying tables are open and buffered, you'll have to update them AFTER updating the view.

HTH
Barbara


>comboA.recordsource:= Select distinct ofc from manentry
>comboA.interactivechange:= pv_ofc = this.displayvalue | =Requery("vwME_mgr")
>comboB.recordsource:= vwME_mgr
>comboB.interactiveChange:= pv_mgr = this.displayvalue | =Requery("vwME_ofcmgr")
>
>grid.recordsource = vwMe_ofcmgr
>
>vwME_mgr := Select distinct mgr,mgrname from manentry where ofc=?pv_ofc
>vwME_ofcmgr:= Select (yada) from manentry where ofc=?pv_ofc and mgr=?pv_mgr
>
>ManEntry table is indexed on Ofc and Mgr
>
>How do i have the changes made to (yada) fields in the grid change the values in the ManEntry table? I know this is one point of using views, but i think i'm missing something. TIA
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform