:: Forum >>

Numerics displayed in grid multiplied by 1,000

I have a simple grid that is being populated through a visual fox pro application. The grid is created via:

oPartGrid = new HDS.Grid("partGrid", 500, 120, "SSSSNNNS", [60, 90, 30, 120, 60, 30, 60, 50], ["MfgID", "Part Number", "GIC", "Description", "Price", "Qty", "Ext Prc", "Stock"]);

oPartGrid.setSelectionMode("single-row");

The numeric fields (price, qty, ext prc) all appear in the debugger as properly passed to the javascript (e.g. 318, 1, 318) but they appear in the grid as 318,000 1,000 and 318,000

Any suggestions?
Thanks
Stan
Stan
Saturday, October 2, 2010
Are you converting foxpro numbers to strings like:?
ALLTRIM(STR(price,,0))
Saturday, October 2, 2010
http://msdn.microsoft.com/en-us/library/texae2db%28v=vs.80%29.aspx
http://msdn.microsoft.com/es-es/library/cc484411%28VS.71%29.aspx
Saturday, October 2, 2010
http://www.activewidgets.com/aw.formats.number/
number.setTextFormat("####,");
Saturday, October 2, 2010
They are not strings passed from Foxpro. Actually two are currencies and one is an integer. Maybe that has something to do with it?
Stan
Sunday, October 3, 2010
http://msdn.microsoft.com/en-us/library/aa978614%28VS.71%29.aspx
http://support.microsoft.com/kb/192303
Monday, October 4, 2010

This topic is archived.


Back to support forum

Forum search