I just thought that I'd let everyone know that I finally found the source
of this strange behavior.

The reason that this happened was because of a computed column in the table
that was doing a division by zero. When I modified the data so that the
division by zero didn't occur, it all worked correctly.

So, from what I gather, TIBOTable was catching the exception, and instead
of passing it on, it intercepted it and displayed this strange behavior
instead. Anyone know why it would do this?

Thanks,
Joe

At 02:29 AM 7/31/2003 -0700, you wrote:

>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
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/