Hello:
I have just been bitten by SET DECIMALS. (Is there really any use for this besides making programming just a bit more difficult?)
I have a table with values to four decimal places. I use <vfp> transform(thevalue,"999999.9999") </vfp> to create the string representation. With SET DECIMALS set to its default value, a value of 0.0123 is converted to " 0.0100" which loses two digits of precision.
I had this problem with another data item that had more than two decimal places. I wrote a special function to handle it by setting SET DECIMALS to the number of decimal places I needed, doing the transform(), and setting SET DECIMALS back to the default.
Why did I do that? Because the number of decimal places can vary and I was generating a line of print in one line of code, BUT also, because I really do not understand the point of SET DECIMALS.
Could someone please clue me in?
Sincerely,
Gene Wirchenko