At 05:19 PM 10-05-01 +0200, you wrote:

>Hi,
>
>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???


Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________