Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cascading Referential Integrity
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01499588
Message ID:
01500549
Vues:
48
>Yes, you are correct. I am reading the VFP help and that the Persistent relationship has to be established.
>
>But let me, if you don't mind, as you another question. Do I understand correctly that after I build the persistent relationship and build the RI the code in the database will be something like this (pseudo code):
>Use Table1
>update Table1 set FieldA = cSomeValue where FieldA = cOldValue
>and son on for other tables?
>
>I am just trying to have a sneak preview of what the resulting code will look like.
>
>Thank you.

You will get something like

ri_insert()
ri_update()
ri_delete()

in the trigger's fields in the database. The trigger's code will be in the code in the Database (you'll see it when you do Modify Code).

It will be a lot of procedural and quite complex (in terms of verbosity) code.

You can alternatively look into Downloads section here to get somewhat cleaner code and easier to maintain/understand.

This is if you go with Doug Hennig's code. I think Walter Meester also has a Downloads here.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform