>>Hello,
>>
>>When I use a "Calculate Sum(Invtotal) to X" command, Foxpro makes X a currency field. I am trying to replace a field in a table (defined as N(9,2) and always get 0 in the receiving field. I know why I have zeros, but I don't know HOW to change the type field in X. Anybody have any ideas?
>>
>>Any help would be appreciated.
>>
>>Barry
>
>Can you use the MTON() FUNCTION?
Hi Bill,
Thanks for responding. I can use the Mton() function in the Command window and it works perfectly. In my program is crashes my system with the infamous message:
"The program has performed an illegal operation and will be shut down"
It's straighforward code.
Calculate SUM(seldetail.total) to X
After execution X looks like $ 7.4000
My next instruction is x = mton(X)
and the system crashes. I'm using VFP 5.0. 64MB. Dont' understand it. Any ideas?
Thanks Again,
Barry
If at first you don't succeed......SET STEP ON!