Subject | Deleting cascading tables with IBO? |
---|---|
Author | Martin Schmid |
Post date | 2001-05-10T15:19:15Z |
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/>
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/>