Hello I have an add column , but the result is an exponetial number, How can I fix this?
Hello I have an add column , but the result is an exponetial number, How can I fix this?
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
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
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
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