>>Ok, I set compatible on, set decimals to 2, set fixed off.
>
>I don't know about the rest of your question, but I remember this from the
Hacker's Guide:
>
>"SET COMPATIBLE ON is an oxymoron, as we discuss in the reference section. Not only does it make the language less compatible with anything else out there, but it breaks code left and right in ways you can't even imagine. Originally, in the FoxBASE days, this was a way to have your cake and eat it, too: fast Fox code wrapped within an IF FOX….ENDIF routine, and compatibility if you needed to compile with other Xbase languages as well. But there are so many places where dBASE and FoxPro have parted company that this command should never make it into a production system."
Thanks, Bret. May be this is the problem.
If it's not broken, fix it until it is.
My Blog