VFP stores numeric(N) data type in a table as a string. As result it has to reserve 1 additional position for a sign and one for a decimal point.
Why it's a problem?
>
>I create a table in MsSQL with
>
>CREATE TABLE Test (test Decimal(10,0))
>
>
>When I query from this table
>
>SQLEXEC(1,"SELECT * FROM Test","cuTest")
>
>Then the field Test.test is 12 decimals.
>How can that be, and how can I avoid this inconsistency?
--sb--