I have a table (Products) with the following keys:

KBSolidVO
KBSolidWH
KBSolidBK
KBSolidRED
KBSolidsIND

I have verified this with other tools, so I know that these are correct.

In my app, I connect a TIBOTable to this table, and connect the TIBOTable
to a Grid. I open the table, and it shows the following keys:

KBSolidBK
KBSolidBK
KBSolidWH
KBSolidsIND

(Yes, it shows KBSolidBK twice, and doesn't show KBSolidVO or KBSolidRED at
all)

Ok, now I have a TIBOQuery. I attach it to the same TIBOGrid. I set the
SQL to:

select * from products

Here are the keys that I get in the grid:

KBSolidVO
KBSolidWH
KBSolidBK
KBSolidsIND

So, in this case, BK is only there once, and VO is back, but RED is still
missing.

Final test. Still use TIBOQuery attached to the grid. I set the SQL to:

Select * from products where PRODBARCODE = 'KBSolidRED'

When I open the query, I get an Access Violation. I DON'T get the access
violation if I search on one of the other keys.

Does anyone know what's going on? Is it a bug in IBO? I'm using
IBO2.Gc. I've thought of upgrading, but before I do, I'd like to know if
this is a known bug or not.

Thanks,
Joe