>Hilmar,
>
>How do you apply VFP RI-builder to SQL server ? because it is not table.dbc
>
>and I have to use SQLEXEC() , SQLCONNECT() command etc... to get infos from
>those tables into temporarily tables in order to delete.
>
>Tia
OK, I thought you wanted to do this in VFP. If you say "SQL", this might mean "the SQL language", which is also available (in part) in VFP.
In SQL Server, you should search for the referential integrity options provided by SQL Server. I don't know how to do it, but I think the same basic principle applies: if you specify a cascading delete (I think they would use the same name), then a deletion in one table would automatically trigger the deletion of related records in other tables.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
