--- In IBObjects@yahoogroups.com, Daniel Rail <daniel@a...> wrote:

> Hi,
>
> > qryBudgetItems is a TIB_Query and I am not using ActiveX at all

in

> > this program. I am running the routine in the associated
> > transaction's AfterCommit event - I presume this is OK?
>
> What happens if you put your code in BeforeCommit? I suspect that

in

> AfterCommit, the OldValues might no longer be available.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)

Daniel,

It does exactly the same thing - this was the way I originally had
it (and I've changed it back, as I thought the same as you did). The
error message looks like it has nothing to do with the actual
problem, which isn't much help!

Gary.