Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric overflow
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01236596
Message ID:
01237187
Views:
24
thanks everyone,
i just added in lots of 0's and it worked
~M

>Mark,
>
>You are creating to fields that are N(4,2) which apparently is not big enough to accommodate your results, try using more zeroes like
>
>
sele *, 0000000.00 as field1, 0000000.00 as field2 where.. into cursor temp1 readwrite
>
>>hi all,
>>I have a problem updating a writable cursor. basically it goes like this
>>
>>sele *, 0.00 as field1, 0.00 as field2 where.. into cursor temp1 readwrite
>>do while not eof
>>
>>    repl field1 with numeric_value * 2.5
>>    repl field2 with field1 * other_numeric_field
>>
>>    loop
>>enddo
>>
>>i get a numeric overflow error on these two lines sometimes but i have no idea why, any ideas?
>>~M
Go raibh maith agat

~M
Previous
Reply
Map
View

Click here to load this message in the networking platform