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?
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?
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[][]"
Regards,
Data Access Worldwide
Vincent Oorsprong
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
Peter H. van Wijk
X-Sources International B.V.
X-Organize Consultancy N.V.
I may look at some changes in my SQL class Library to do something similar