Hi Handoko,

This is an interesting problem which is common to many countries,
Italy with the Lira and Spain with the Peseta come to mind, Turkey,
many countries in Africa too, and in South America.

In my many travels around the world what I have usually found is that
while at "street level" it is possible to deal in tens and small hundreds
of the local currency, for example when buying something in a market,
at "business level" in 90% of businesses one almost never ever buys anything that is priced lower than, say, one thousand units of the local currency.

Therefore, depending on whether that suits you or not, you could always
decide that what you will be holding will be purely units of thousands.
For instance, if your numeric field holds 1,357, then you would
display on screen 1,357,000 IDR.

This is just one solution. I would be extremely interested in learning
how the Italian, Spanish, Turkish, etc..., Universal Thread members
handle their local currencies given that, often, prices could
exceed the FoxPro limitations.

Michel.

================= Original message follows =====================

>In Indonesia, Oracle is more popular now, and many people is not sure about FoxPro capabilities. For example, numeric field issue.
>
>In Indonesia, foreign exchange (FX) for US$1 about IDR8000 now, and FX have achieved US$1=IDR16000. If accounting in IDR currency, it's possible more than 20 digits used, as number/value, amount from sum of US$ or GBP time with IDR rate. I have tried, FoxPro accept less than 20 digit for numeric field.
>
>But, I like FoxPro because I think FoxPro more simple than Oracle.
>
>If we have a stand alone program in Visual FoxPro, but data have been already in Oracle database, so we have to download/import (or export from Oracle) and we need to process it in Visual FoxPro as a numeric field too for use Math Functions.
>
>Do you have more command/suggestion (Oracle vs FoxPro)?