--- In IBObjects@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> Dan,
> I have no idea what is wrong, but reading your mail left me with a

couple

> of questions that may help others help you.
>
> 1) Is this a program that is working perfectly at other locations?

This is a conversion to IBO that has worked perfectly as is for the
past 2 years as a BDE program.

> 2) Has there been any changes to the code recently?

Only the IBO conversion.

>
> This will rule out things like doing DDL through code giving

the "too many

> versions" or something error.
>
> 3) Does the error always occur when working on the same data?

Any data. Same query. Query SQL unchanged in 3 years.

>
> We only know that your problem occurs at the 27th execution every

time. We

> do not know if every execution is independant of other executions

or if

> there is a particular sequence. I assume the error always occurs

when

> working with a set table, but is it dependent on which record it
> reads/modifies?

Totally independent. Any set of records passing through that code
get nailed.

>
> 4) What version of IBO? Server? Is forced writes on? IB_Query or

IBOQuery?

IBO hf release. Interbase 6.5 server. 5.6 client or 6.5 client. 6.5
stand alone. 5.6 server tested as well. Forced write is on. IBO
query because of the conversion.

>
> By the way, with IBO it is not necessary to call Open before

calling First

> (at least not when using native components). Try removing the call

to Open

> and see if that makes any change.
>

The call to open was after a call to close to refill the paramweters
to get new values.

Close
load new params
open.

first is irrelevant.

> Set