Zeros in decimal places

[SJG0526]

I need to show zeros at the rightmost decimal place(s) if the user entered them. If they didn't, I don't want to show the zeros. Example:

entered 4.90 needs to show as 4.90 on all screens/reports and needs to be save in the database as 4.90

entered 4.9 in the same field, needs to show 4.9 on all screens/reports and save in the database as 4.9

These need to be treated as numbers, not strings

Possible?

 

[djj55]

Hello, this problem has been around for a while, I will be watching this thread.

In the past I have had two columns in my tables, one with a character string and one with the numeric. That way the trailing zeros are saved but you have a column to work with for calculations.

Good luck.
djj

 

[ca8msm]

I guess you'll have to save them as a string in the database and display them like that as far as a numerical value is concerned, 4.90 equals 4.9.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[arkomnv]

I believe you just handle them in your database as a string
and when you need to calculate convert the numbers to a decimal value or whatever you need

example:

DecimalNr = CDec(StringTextFromDatabase)