Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>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.
How do i determine the key field? Does it have to be a unique id value?
Could you better explain that last part? I get from it that before i use the =Requery() that i should use TableUpdate (on the view?) I don't understand what you mean about updating the tables after updating the view. (tableupdate(view), then tableupdate(maintable) then =requery(view)?)
I'm sure by now UT'ers know that PBP trains developers by making vague requests and then pushing up the deadlines. Thanks again for all your help.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement