Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integer compatibility issue with SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Miscellaneous
Thread ID:
00919111
Message ID:
00919388
Views:
20
Hi Stephane,

It's VFP limitation documented under Visual FoxPro System Capacities in help:
Minimum value of an integer -2,147,483,647 
Maximum value of an integer  2,147,483,647
>There is a compatibility issue with VFP and SQL Server.
>
>An Integer max and min values in VFP is from -2,147,483,647 through 2,147,483,647
>
>And in SQL Server from -2,147,483,648 through 2,147,483,647
>
>This can cause a problem when storing a value of -2,147,483,648 in SQL Server and attempting to use it in VFP.
>
>This compatibility issue was present in VFP8 and is still there in VFP9 Beta.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform