Hi Garrett,
thanks, now I have understood all.
My mistaken is for Numeric attribute, on MSQL numeric is fixed point.
you can comment my affirmations?
- VFP haven't DECIMAL data type.
- Then only fixed point on VFP are CURRENCY and INTEGER.
- N(X,Y) is LEFTFLOAT(X): X positions with max Y decimals.
- VFP convert MSQL field DECIMAL(X,Y) to N(X+2,Y),
but calculation is done with this schema:
- every N(X+2,Y) is read from table and convert to double floating point memory variable
- any intermediate value is stored in double floating point memory variable
- ROUND(result,Y) is stored into the N(X+2,Y) field.
- VFP support MSQL field only for read or for write edit value;
to execute a sum in VFP and MSQL of the same table numeric values can give various result.
-Sums of identical integers in VFP and MSQL return always equal integer value? Yes, eccept for -2147483.648.
- Sums of identical currency in VFP and MSQL return always equal integer value? Yes, eccept for -922337203685477.5808.
- Sums of identical double in VFP and MSQL return always equal integer value? No?
- Sums of identical nemeric in VFP and MSQL return always equal integer value? No.
----
My comment: all this is worse than a bug, it is a virus.
Thanks
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only