Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>Your view must be an updatable view.
>>>
>>>I also have this as two pagespageframe form - first is a Grid View and second is a one record view with all fields.
>>
>>ok i did the thisform.refresh,grid is readonly.
>>but help me here
>>where do i set the form view to updatable and also when u say form has 2 be bound 2 the same view u mean my fields need 2 have the view as its control source?
>
>When you design the view in the View Designer there is a tab for Marking which fields are updatable and how the updates are send to the table. You also need to identify the primary key there.
>
>Yes, your textboxes will have MyView.Field as their controlsources. The Grid will have myView as the RecordSource as well.
oh the edit box and grid works but the values doesnt get updated
in the view designer i see Update Criteria.
I also see all my field for my grid. but none of them are keys. Do i need 2 click the "key" and "pencil" icon?
oh SQL updateS?
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