At 09:25 AM 14-08-01 -0600, you wrote:

>Ive got a weird one. My app is working fine about 99% of the time. Sometimes
>however, the system does a query, and is returns a row from another
>customer. This is very rare, but does happen. Could it be a corrupt index of
>some kind? Does this happen in IB? I am performing these queries in Stored
>Procs.

No, it shouldn't happen. We'd need to see the DDL involved to work out why this happens to your app.

Corrupt indexes don't work. Your application could, through some kind of logic error, write a wrong value in a key, thus "corrupting" data integrity.

More info please.

Regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________