Grid with exponential numbers

[gontran]

Hello I have an add column , but the result is an exponetial number, How can I fix this?

[barrymavin]

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.

[gontran]

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

[barrymavin]

Hi gontran

can you package up your app including the data and attach to a ticket and I will look into it for you.

[barrymavin]

Hi Gontran,

Thanks for providing the App and Data. I have corrected this in 6.3.