Hi John,
Thanks for the reply. I'm looking for a way of adding a stored procedure to an existing database though without the use of the foxpro development environment.
I have an upgrade script, that uses SQL commands to manipulate the tables when the user first runs a new version and want to do something similar for the triggers to delete child records when the parent record is deleted.
Tks,
Dennis
>Hi,
>VFP come with Referential Integrity Builder to help us to do what you mentioned. It allows us to define "action" should be taken if INSERT/UPDATE/DELETE happens to the tables such as cascade for delete (delete all child record if parent record is being deleted).
>
>That is a freeware tool TaxRI in download section which generate better stored procedure code for this purpose.
>
>Note, before this, make sure you have define the relationship between tables in your database.
>
>HTH