--- In IBObjects@yahoogroups.com, "tickerboo2002" <support@t...> wrote:

> I'm using a TIB_Query to select a number of rows, insert a row and
> then delete that row and I get an exception "Unable to delete row".
>
> Tracing into IBO, I see that I need to be out of dssInsert state, so I
> called Search() prior to the delete. Now, it fails on the rowstate
> being rsNone.
>
> Should I be able to insert and then delete the newly inserted row
> within posting/commiting?
>

Use ".Cancel" to cancel insert state (so you loose the "client side
only inserted record").
regards
Marco Menardi