Results 1 to 5 of 5

Thread: SQL Result Values

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Posts
    2,165

    Default SQL Result Values

    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?



  2. #2
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: SQL Result Values

    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

  3. #3
    Join Date
    Feb 2009
    Posts
    2,165

    Default Re: SQL Result Values

    I actually wondered if a variant would be better

  4. #4
    Join Date
    Feb 2009
    Posts
    1,270

    Default Re: SQL Result Values

    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.

  5. #5
    Join Date
    Feb 2009
    Posts
    2,165

    Default Re: SQL Result Values

    I may look at some changes in my SQL class Library to do something similar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •