Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Overflow of value in field
Message
From
19/04/2007 17:33:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01218060
Message ID:
01218062
Views:
14
This message has been marked as the solution to the initial question of the thread.
>I have a situation where I cannot get rid of all of my BREAK (Steel wire break point) OVERFLOW values. I have written an import and everytime it comes to the break field with ten asterisks **********, the program bombs and says "overflow". How do I correct the data that has all of the asterisks in them? When I look at how many asterisk there are in the field, it looks like 5 or 6, but when I do something like
>
>lcBreak = certs.break
>?LEN(STR(lcBreak))
>
>I see the number 10, so maybe there are 10 asterisks.

str(), without a second parameter, will fill the expression to 10 bytes, so that is why you get the number 10.

>But, how do I REPLACE ALL of these fields which contain the asterisks. I get an error when I try the command:
>
>BROWSE FOR certs.break=**********

I think this should work:
browse for break = 1/0
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform