Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to come up with a view/CA model
Message
From
08/07/2009 15:16:16
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01410693
Message ID:
01411006
Views:
42
>>>>10 - [2147483647] if you only use positive values and 11 with sign if you have negative [-2147483647]
>>>
>>>Yes, I was just testing it in Command Window. So, 12 should be more than enough :)
>>
>>Sure :-)
>
>Well, I tried
>
>CREATE CURSOR cc (Idd I)
>INSERT INTO cc VALUES (2^31)
>?PADL(idd,12,'*')
>INSERT INTO cc VALUES (2^31-1)
>?PADL(idd,12,'*')
>
>and it got me thinking - may be Jon has some errors like this in insert command that causes abnormal behavior.

The range is from (-2^31+1) to (2^31-1) :-))))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform