Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>
>>try using VIEWs
>>also what RI code have u set for the child table
>>
>>Arnon
>
>could you explain a view, and what RI stands for. thanks
views are sort of like the cursors a regular SELECT SQL produce
but they have much more power ,e.g. if u update the data in a view u can sent the updates to the parent tables - u can read on VIEWs in the VFUG tips'n'tricks section, oh, and the VFP manuals (actually the manual is not thta bad)
as to RI - that is refrential integrity u various rules that VFP lets u set for related tables (of course u can also write your own)
e.g. VFP lets u set a father table so that u can not delete a record if it has children in the child table etc.
Arnon
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