Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Money vs Real type
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01436543
Message ID:
01436556
Views:
41
Almost. In VFP the Numeric type is stored as a string in a table. Because of that, 12 includes a position for a '-' (minus) for negative numbers and a position for '.'(dot). As result Numeric(12,2) in VFP leaves only 10 digits for negative numbers and 11 for positive.

>When defining a Numeric type, are the parameters carry the same meaning as in VFP? That is, if you define Numeric(12,2) would be the same as in VFP (up to 12 digits and 2 decimals)?
>
>>The data type you're looking for is Numeric/Decimal (synonyms)
>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform