Subject Deleting cascading tables with IBO?
Author Martin Schmid
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?


Mit freundlichen Grüssen - best regards

Martin A. Schmid
Geschäftsführer
EQUITANIA GmbH
Das Programmierteam

Online:
Info@... <mailto:Info@...>
http://www.EQUITANIA.de <http://www.equitania.de/>
P.S.: Besuchen Sie auch http://www.Schmuck.de <http://www.schmuck.de/>