>>Also i don't think FoxPro is a common tool for data warehousing
>>purposes.
>
>It's not a common tool *yet*. However, fox's DML make it a great tool for front-ending and loading a data warehouse. We have quite a few dw's out there utilizing VFP.

Have been using FPD 2.6 for two years for a data warehousing application that stores over 1 million records and allows ad-hoc inquiry by users -- it has been working very well. I'm sure VFP will make it even better when we get around to that.