Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RI Code
Message
 
À
19/05/2003 10:13:10
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00789968
Message ID:
00790506
Vues:
23
Hilmar,

thanks a lot for your answer, somtimes it really helps to go one step back,
or write a question on UT to get around not seeing easy things.

>Why do you need to mess with the RI? Usually, you can just add functions like this:
>If your RI-code is: __ri_MyTable_Update()
>You convert it to: __ri_MyTable_Update() AND MyAdditionalFunction()
We already tried your solution quite a while ago and ran into the following problem: This works fine as long as the trigger is called directly. Lets say you habe 3 tables: Table1, Table2, Table3 wich have RI for cascading delete.

The __ri_MyTable_Update() of Table3 works fine when I delete a record in Table2. I get into my code and have the record wich is planed to delete as actual record.

If I delete the according record in Table1 my Table3-Code fires, but the record pointer of table3 stands anywhere? So I can't find out wich record is planed to be deleted, so I can't perform my action!

Is this a known issue. I am really confused, because I never ran in any problems like this ? Perhaps our RI Code is not OK ? Any ideas ?
Marcus
Marcus Alt
TRIA IT-Consulting GmbH
Working hard | for your success
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform