Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Overflow of value in field
Message
De
19/04/2007 17:33:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01218060
Message ID:
01218062
Vues:
13
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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform