Helen,

you are right!

I mean delete all datas in the table!

--- In IBObjects@y..., Helen Borrie <helebor@d...> wrote:
> 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
> _______________________________________________________