Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BitSet & Integer
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00919018
Message ID:
00919076
Views:
14
>So why is that SQL Server integer definition is:
>
>integer or int
>Has a length of 4 bytes, and stores numbers from -2,147,483,648 through 2,147,483,647.

It's probably handling the math slightly differently. Consider that -2 ^ 31 = -2,147,483,648 and 2 ^ 31 - 1 = 2,147,483,647. This is how SQL Server defines an integer. VFP does the subtraction on both equations not just the one, reserving that for zero.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform