Ok, I just figured out and fixed this one. As usual isolation is 90% of the
battle.

Were you using CalculatedFields with the dataset too? That's the only way I
was able to isolate it... I kind of got lucky because otherwise I never
would have found this I don't think.

This one has been around a while now and it sure feels good to hear this one
go "squish".

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Michael L. Horne" <guardian@...>
To: <IBObjects@egroups.com>
Sent: Thursday, December 07, 2000 10:01 AM
Subject: [IBO] TIB_Query with Delete


> Hello
>
> I setup DeleteSQL so my user could delete records in
> a table that did not request the data with "RequestLive".
>
> DELETE FROM OrdersN WHERE ON_ID = :Old_ON_ID
>
> This worked fine until I deleted all the displayed
> records and tried to delete again. I then got the
> following exception:
>
> Record was not located to delete.
>
> I have a TIB_Updatebar that I am using to do the deletes
> with. Shouldn't the "Delete" button change to Disabled
> when there are no more records. Or at least not return
> the exception.
>
> The exception is thrown in IBA_UpdateSQL.IMP line 791.
>
> The final result I am looking for is a way for the user
> to display the data and delete some of the records.
> Maybe it would be ok to "RequestLive=True" but I don't
> know how that will effect the speed of the access.
>
> Thanks
> Michael L. Horne