Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    20

    Unanswered: Floats showing in Scientific mode

    I am currently running PSQL 9.5 and when I view fields through PCC that contain large currency amounts which have been designated as floats, they show up in scientific mode.

    Is there anyway that I can configure PSQL/PCC to show the actual amount?

    Thank

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    For display purposes, you can use CONVERT or CAST to change the results. I used the following statements:
    Code:
    create table flt1 (f1 float);
    insert into flt1 values (10000000);
    select f1, convert(f1, sql_Char), cast(f1 as char(100)) from flt1;
    and got the following results:
    Code:
         f1   EXPR_1                     EXPR_2     
    =======   ========================   ===========
      1.0E7   10000000                   10000000
    I used PSQL v11 but the statements should work in v9.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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