Hello!

I connect to the EMPLOYEE database using this query:

select cst.cust_no, 

       cst.customer, 

       cst.contact_first, 

       cst.contact_last, 

       cst.phone_no, 

       cst.address_line1, 

       cst.address_line2, 

       cst.city, 

       cst.state_province, 

       cst.country, 

       cst.postal_code, 

       cst.on_hold

from customer cst

order by cst.customer

The ColumnAttributes string looks like this:

CST.ON_HOLD=BOOLEAN='*,-';BLANKISNULL

When running the query and connecting it to a DBGrid all rows display "UNKNOWN" for the "ON HOLD" field.

If i change the ColumnAttributes string to this:

ON_HOLD=BOOLEAN='*,-';BLANKISNULL

Two of the lines display "True" for "ON HOLD".

The reason is that when IBO are to read the '*,-' part of the string the Relation Alias is not computed yet.

Put a breakpoint on line 1815 in IB_ParesEx unit (GetColParamValueEx, after the assignments FFN, FSN and FN) you wee that FullSQLName calling RelAliasName returns CUSTOMER.ON_HOLD and not CST.ON_HOLD as is the case later on.

I'm afraid more info from the LinkListParam is missed too.

Please fix this!

/Dany

BTW - what is wrong with my bug report:

https://groups.yahoo.com/neo/groups/IBObjects/conversations/topics/48838

if there is no tracking system, how do i report bugs??!!