Hello again, Jim.
Believe me, I'm very sorry to bother you again. In the Visual FoxPro's help file is mentioned that the numeric data type can be stored in tables at a maximum width of 20 chars. This is not enough. On the other hand, the Currency data type have the same width. The double datatype in the memory is capable to store a very big number, but if I try to issue
REPLACE My_DoubleDataType_Field with 12345678901234567890123.12
the value stored is truncated, and this behaviour is unnaceptable in a finacial application.
Thus, I've found that I cannot use any of the numeric datatypes. The sollution I've found is to store the numbers in a character field and index the field onto VAL(field). In this way, when I SEEK a value, I'll get the numeric value, and when I try to store a numeric value in the table's field, I'll store the ALLTRIM(STR(value)).
What do you think about this?
Thank you again
Grigore Dolghin
Grigore Dolghin
Class Software.