Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RI Code
Message
From
19/05/2003 10:32:30
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00789968
Message ID:
00790002
Views:
19
>Hello,
>
>we are using referetial integrity in out DBC. Works pretty fine. We now need to put in a own stored procedure wich is triggered by an existing RI Trigger but does things you can't do with RI.
>
>We ended up with try and error, when putting own code in.
>
>Is there any documentation about the RI Code procedures that VFP uses and what they do. We need to use them to get things running but are really in lack of information.
>
>
>Marcus

Marcus,

(1) Can you replace the name of the current trigger (say __RI_update_customer()) with __RI_update_customer() and MyTrigger(). This has to be done each time you rebuild the ri.

(2) As to the documentation, there is RIBUILDR somewhere in (Tools\xSource\xSource.Zip). But I think it will be faster to build a test database with a few tables and relations, build the RI and look what it does. That's how I've done it (took me a week). I have a table set up where I can add lots of procedures to be called when any table is changed, either before or after the RI trigger is fired. Once you get there, it's fun

(3) There's also the TaxRIbuilder in the download (I have not seen it)

The fastest is (1). The nicest is to create your own, if you have the time this is
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform