Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pview, combo and grid
Message
 
À
01/05/2000 15:19:27
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvanie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00364856
Message ID:
00364948
Vues:
16
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform