Subject Re: [IBO] Deleting cascading tables with IBO?
Author Helen Borrie
At 05:19 PM 10-05-01 +0200, you wrote:
>I have create a master table and some detailtables.
>The detailtables have foreign key to the master table.
>The foreign key are cascade on delete.
>If I use the statement:
>DELETE FROM mastertable;
>On the SQL Editor from IBExpert, the master and all detailtables will be
>delete without problems.
>If I use the IB_Script component with the same statement, I got foreign
>key error messages!
>What is different at IBO?

Strange...DELETE FROM should not delete tables! Are you sure that is what it does in IBExpert???


All for Open and Open for All
InterBase Developer Initiative ยท