I have just discovered that the method
Function SQLFetchResultsetValues Returns String[][]
returns numeric fields that are contain 0 as .00 not 0.00
SMS returns them as 0.00
is there a reason for this?
[h=1][/h]
Printable View
I have just discovered that the method
Function SQLFetchResultsetValues Returns String[][]
returns numeric fields that are contain 0 as .00 not 0.00
SMS returns them as 0.00
is there a reason for this?
[h=1][/h]
Chris,
AFAIK DataFlex always dropped the trailing and leading zeroes when converting a numeric value to a string.
Not sure if it would be better if "returns string[][]" was changed to "returns variant[][]"
I actually wondered if a variant would be better
In my SQL class if convert the data depending on the field_type of the database field. So loop over the result set and format it properly.
The result is or a DataSourceRow or an array, that is mostly string[][] but also a variant[][] where I Cast to put into the variant with the field_type of the field.
But would be nice to have a call "SQLFetchResultsetVariants" in Nextgen.
Peter
I may look at some changes in my SQL class Library to do something similar