>>>>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.