Subject Re: [IBO] Strange behavior in TIBO_Table based app
Author Helen Borrie
At 01:07 PM 6/04/2003 +1000, you wrote:
>I have a small app using TIBO_Table and Delphi 5 Data aware controls to
>access a single FB1.0 table. I am the only user, it has been working fine
>for a couple of months, now any attempt to scroll throught the table results
>in the cursor "sticking" on various records.
>If I jump to the begining or end of the table and attempt to navigate, the
>cursor jumps back to the same records. I have backed up and restored the
>database, to no effect.
>If I use IBO_Console to look at the table it scrolls through the data with
>no problems.
>Does this sound like a data corruption

Not if you were able to restore from your backup. It might have been an
index balance problem but backup/restore should have fixed that.

>, or a software problem?

Did you change something?

>and if bad data, what is the best way to fix it?

If so, the first step would be to find it. Drop a TIB_MonitorDialog into
the app and watch the parameters that get passed just before the anomaly
occurs. Note the PK value of the rows that seem to cause the problem and
look at them in the Cursor table of IB_SQL.

Other than bad data, what's the environment? For example, are you using a
Win local connection? It could be a memory capacity problem, or a race
condition, that has arisen due to table growth...if you are using a local
connection, try changing to local loopback - use the localhost server and
set the Protocol to cpTCP_IP.

Apart from that, no ideas absent further clues.