Results 1 to 5 of 5

Thread: Grid with exponential numbers

  1. #1
    Member
    Join Date
    Oct 2012
    Location
    México city
    Posts
    70

    Grid with exponential numbers

    Hello I have an add column , but the result is an exponetial number, How can I fix this?
    Name:  2021-11-21.jpg
Views: 57
Size:  89.0 KB

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,719
    Blog Entries
    17
    Hi Gontran,

    I will look into that. Try making the column wider and see if that helps. You can set the grid column to a fixed width by clicking on the column header then check “fixed width” in the attributes then specify a value or alternatively hold the mouse down on the right of the column header and drag the resize handle.

    Look at the format mask for the total also. This is in the column attributes. You may need to provide a mask with more digits such as 999,999,999.99

    Also, looking at the data you must have import that from VFP and it needs converted to UTF-8 encoding.

    To do this.

    close the app

    in the console type

    backup database <name of database>
    convertutf8 database <name of database>

    then reopen your app and see if characters are displayed properly.

    If it’s the runtime database that needs converting you will need to copy this to lianja\data\databasename convert it then copy it back.
    Last edited by barrymavin; 2021-11-21 at 18:19.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Member
    Join Date
    Oct 2012
    Location
    México city
    Posts
    70
    Hello thanks for the help, I set "fixed with" abd use mask ###,###,###,###,###.##, but continue with exponential numbers. Any idea?

    And I use the covertutf8 but continue with simbos and no ascents. I thing this is an error comes from VFP this data come from old VFP program.

    Thanks for any idea

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,719
    Blog Entries
    17
    Hi gontran

    can you package up your app including the data and attach to a ticket and I will look into it for you.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #5
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,719
    Blog Entries
    17
    Hi Gontran,

    Thanks for providing the App and Data. I have corrected this in 6.3.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us