Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding large numbers
Message
From
13/09/2013 08:04:55
 
 
To
13/09/2013 05:09:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01582980
Message ID:
01583124
Views:
53
>>If I'm running this code, the result is incorrect, because VFP cannot handle that large numbers.
>>What would be a workaround?
>>
>>CREATE CURSOR cuTest (test c(20))
>>FOR lnNr = 1 TO 7000
>>	INSERT INTO cutest VALUES ("123456789012345")
>>endfor
>>SUM VAL(test) TO lntest
>>
>
>
>Does this work?
>
>
SELECT CAST(VAL(test) AS Currency) AS nBigNumber ;
>    FROM cuTest ;
>    INTO CURSOR c_temp
>
>SUM nBigNunber TO lnTest
>
>* Or, use a direct SUM() in the SQL SELECT.
It gives an error "Currency value out of range".
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform