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@...>
To: <IBObjects@yahoogroups.com>
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