>Hi all
>
>How can I go about writing a small prg which creates relations between given tables and their corresponding PK and FK field names?
>
>I would also like to setup RI compatible triggers in the same program.
>
>Please advise of how to go about programming such a utility, or is one already available for downlaods anywhere.

To add procedures to the stored procedures, see APPEND PROCEDURES.

To modify a trigger to a table, see CREATE TRIGGER.

The actual trigger function for RI would have to search the key value, check in related tables, and return .T. or .F., depending on the type of trigger, and on whether the value is found.

For example, for a delete trigger (in the parent table), if the value is found in child tables, the function should return .F. (DELETE is not allowed). Otherwise .T.

For an insert or update trigger (in the child table), if the value is NOT found in the parent table, your function should reurn .F.


If you want to redesign the RI completely, I have an idea that it might be interesting to use a single RI-function for all tables, and use a table-based approach. In other words, have your RI-function check a "relations" table, and search according to the parameters it finds there.

Then, to redefine RI, you don't even need to recompile the stored procedures.


On the other hand, I don't know whether such an effort is worthwhile; you can just as well use the built-in RI.

Greetings,

Hilmar.