>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