>Changing the code to int in convert fixed the problem. Weird, does it mean VFP converts biging to char type?
>
Yes
How to convert VFP this from SQL Server? ;o)
bigint
-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst