Set up referential integrity, and use cascading deletes. The Visual FoxPro RI-builder, or an alternative builder like the freeware TaxRI, will automatically generate all the required code.
>Hi all,
>
>How to do multiple deletion with many tables in SQL ?
>
>table1
>number
>desc
>
>table2
>number
>desc2
>
>table3
>desc2
>id
>
>table4
>id
>amount
>
>table5
>amount
>supplier
>
>....
>
>this is a parent to children deletion in a single SQL - statment if possible
>
>table1 and table2 linked with number
>table2 and table3 linked with desc2
>table3 and table4 linked with id
>table4 and table5 linked with amount
>
>and so on
>
>Any suggestions or coding would be appreciated very much.
>TIA
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)
