> 1. Error:
> When odering by a Column that has Values and Null Values
> normally the values are desplayed first then Null Values last.
>
> If HDR is active all Rows that are Null in the Column are filtered out
> and not displayed at all. Note I also can't scroll into those rows.

HDR doesn't work with NULL values and I need to document that more clearly.
I would like to get it to work with NULLs but I don't know how to do so and
maintain queries that optimize well.

> I have a Column with a Numeric(15,2) not null definition. Defined as Money
> in IBO.
> When I order by this normally without HDR it works.
>
> When ordering with HDR I get (upon pressing the little ordering Icon in

the

> header):
>
> EConvert Error: -9223372036854775808 is not a valid floating point value:
>
> in IBA_BDataset.INT line 2876
> going into IBA_Column.INT
> and throwing the exception on line 2308
>
> the problem looks to be that the code is assigning the smalles possible

INT64

> value to a currency field that does uses the last 4 digits as scaling.
>
> call stack:
> TIB_ColumnNumeric.SetAsString('-9223372036854775808')
> TIB_BDataset.SetOrderingRefineStr('-9223372036854775808')
> TIB_BDataset.SysBeforeExecuteForOutput
> TIB_Statement.SysExecute
> TIB_Dataset.SysExecute
> TIB_Dataset.SysOpen
> TIB_Dataset.SysRefresh(False,???)
> TIB_Dataset.RefreshKeys
> TIB_Dataset.SetOrderingItemNo(???)
> TIB_CustomGrid.UpdateOrdering(???,???)
> TIB_CustomGrid.MouseUp(mbLeft,[],429,11)
> Application

I need to take a closer look at this. I've logged this in my bugs list.

Thanks,
Jason Wharton