Subject | HDR Errors |
---|---|
Author | Christian Mautendorfer |
Post date | 2003-08-01T22:48:21Z |
Hi,
started playing around with HDR, now that I know it works.
It gives a wonderfull speedup to some things so congrats
Jason on a great feature.
I also found 2 Bugs:
System Win2k FB1.5 (RC3-4). IBO 4.2fTest
All displays happen in a TIB_Grid
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.
(2 not null and 3000 null values)
2. Error:
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
--
--Chris
started playing around with HDR, now that I know it works.
It gives a wonderfull speedup to some things so congrats
Jason on a great feature.
I also found 2 Bugs:
System Win2k FB1.5 (RC3-4). IBO 4.2fTest
All displays happen in a TIB_Grid
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.
(2 not null and 3000 null values)
2. Error:
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
--
--Chris