Re: SET DECIMALS Gotcha

On Sun, Jul 30, 2017 at 6:38 PM, Gene Wirchenko genew@telus.net wrote:

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.

If you use STR(thevalue,11,4), you should get the result you want.