Version: 13.0-alpha-4
Build #: 30585
Build Date: 2012-Dec-12 09:25:17 AM
Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_35-b10
Memory: Max=891,092,992; Total=243,662,848; Free=146,366,112; CPUs=8
1. execute the script below
2. in the Grid Results, click the column header of "column1" to sort it descending.
3. notice that the list begins with 9, ends with 1, but that 10 is second from last.
Is there something in File > Options that could be causing this?
see attached screenshot
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 2D High Low Close Chart
--
-- Notes: The query below will work on the following database servers:
-- MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, MySQL, PostreSQL
--
-- ORACLE: To make the query below work in Oracle, add " FROM DUAL" at the end of each SELECT
-- DB2: To make the query below work in DB2, add " FROM SYSIBM.SYSDUMMY1" at the end of each SELECT
-------------------------------------------------------------------------------------------------------- -----------------------------------------------------
SELECT '1', 'BBC' as 'Company',30 as 'high', 10 as 'low', 27 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '2', 'CBC' as 'Company', 30 as 'high', 15 as 'low', 20 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '3', 'ABC' as 'Company', 70 as 'high', 63 as 'low', 68 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '4', 'STC' as 'Company', 59 as 'high', 46 as 'low', 57 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '5', 'WIP' as 'Company', 9 as 'high', 3 as 'low', 5 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '6', 'INF' as 'Company', 23 as 'high', 12 as 'low', 22 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '7', 'ADS' as 'Company', 50 as 'high', 38 as 'low', 47 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '8', 'TOA' as 'Company', 60 as 'high', 40 as 'low', 55 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '9', 'CAA' as 'Company', 55 as 'high', 42 as 'low', 48 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '10', 'YAH' as 'Company', 65 as 'high', 54 as 'low', 58 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '11', 'MIC' as 'Company', 80 as 'high', 65 as 'low', 74 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '12', 'TCS' as 'Company', 65 as 'high', 40 as 'low', 55 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '13', 'CRA' as 'Company', 35 as 'high', 10 as 'low', 30 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '14', 'TWI' as 'Company', 40 as 'high', 20 as 'low', 28 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '15', 'GOO' as 'Company', 76 as 'high', 46 as 'low', 65 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '16', 'PLU' as 'Company', 55 as 'high', 32 as 'low', 42 as 'close', '20081209 13:12:43.280' as 'date'
GO
.setResultSettings 'Index=1,
CategoryFields="[Company]",
SeriesFields="[high] ASC,[low],[close]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=0,
Chart="{highlowclose,highlowclose,highlowclose}",
RotX=324,
RotY=0,
RotZ=0,
ZoomScalar=1.1525923,
ShowLegend=true,
ShowLegendBorder=true,
ShowGrid=true,
FillGrid=true,
GridLineWidth=1.0,
Title="2D HLC Chart",
TitlePosition="Bottom Center",
TitleCategory="",
TitleValue="",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
ShowMarkers=true,
MapShowBackground=false,
MapShowDetails=false,
MapRange="",
MapRangeColors="",
Width=16.0,
Height=10.0,
Depth=4.0,
SeriesSpacing=0.5,
CategorySpacing=0.5,
Font=Arial-6,
LegendFontSize=1.0,
SeriesFontSize=1.0,
CategoryFontSize=1.0,
ValueFontSize=1.0,
TitleFontSize=1.75,
AxisTitleFontSize=1.25,
DataLabelFontSize=1.0,
TopColor=#D7DCF5,
BottomColor=#EBF0F5,
PanX=-263.5,
PanY=-128.1,
Lighting=Default,
Opacity=1.0,
View2D=true,
FitChartToImage=false,
StackedPercent=false,
ShowValueAxis=true,
ShowValueAxisTicks=true,
ShowValueAxisLines=true,
ReverseValueAxis=false,
ShowCategoryAxis=true,
ShowCategoryAxisTicks=true,
ShowCategoryAxisLines=true,
ShowSeriesAxis=false,
ShowDataLabels=false,
ValueAxisNumberFormat="###0",
CategoryAxisNumberFormat="#,##0",
CategoryAxisDateFormat="",
CategoryAxisDateTimeFormat="",
CategoryAxisTimeFormat="",
SeriesAxisNumberFormat="",
SeriesAxisDateFormat="",
SeriesAxisDateTimeFormat="",
SeriesAxisTimeFormat="",
NumericCategoryAxis=false,
MergeAxis=true,
SeriesAlias="default,default,default",
SeriesSubType="High,Low,Close",
SeriesColumnType="Cube,Cube,Cube",
SeriesMin="default,default,default",
SeriesMax="default,default,default",
SeriesColor="#40699d,#9f413e,#809b48",
SeriesFunctionMetaData="true,true,true",
ShowSeriesDataLabels="false,false,false",
LegendPosition=Top Right,
LegendWidthType=Exact,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=true,
FixedCategoryCount=0'
My ignorance creates bugs all the time. :-) This is functioning correctly, the numbers are being interpreted as strings, not numeric or integers