Dear Jason ,

Thanks a lot,

sometime I need to delete all the detail records,
in order to let user reassign detail records.
so I cannot use trigger or delete cascade.


Kadee

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> If you setup triggers in the master table to automatically
delete the detail
> records that makes it much easier. You can also use
declarative referential
> integrity and have deletes cascade.
>
> Also, to use cached updates for something like this is
overkill.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: "bigred17201720" <kadee@p...>
> To: <IBObjects@y...>
> Sent: Thursday, September 05, 2002 9:37 PM
> Subject: Re: [IBO] how to delete all record in Tiboquery?
>
>
> > Thanks to all reply.
> >
> > I explain my situation.
> >
> > I have one M/D relation form, When user press the
> > <delete> button,
> > 1.I will start 1 transation
> > 2. delete all the detail records
> > 3. delete the master record.
> > 4. apply the detail , apply the master.
> > 5. commit transation.
> >
> > and I also try the follow code with same result;
> >
> > iboquery.first
> > while not iboquery.eof do
> > iboquery.delete;
> > iboquery.applyupdate;
> > iboquery.close;
> > iboquery.open;
> >
> > Kadee