Hi Garrett,

you wan't answer to my list of affermations with yes or no. Why? You can't do it ?

>Repeat after me: FLOATING POINT DOES NOT PRODUCE EXACT RESULTS. IF I WANT EXACT RESULTS, I WILL ROUND MY DATA.

I can't repeat this because is impossible round intermediate result.

Example:

SELECT SUM(field) FROM ...

is impossible round intermediate sum, then is impossible give exact result.

For do it i must rewrite any grouping select with SCAN ENDSCAN.
I must reimplement GROUP BY with index and scan;
for select with join this is a lot of work.

Repeat after me: VFP, EXCEPT FOR CURRENCY, DOES NOT PRODUCE EXACT RESULT WITH GROUPING SELECT. IF I WANT EXACT RESULT, I WILL EXEC CALCULATION ON MICROSOFT SQL OR ANOTHER BACKEND DATABASE WITH DECIMAL SUPPORT.

Fabio