Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding stars
Message
De
14/02/2006 16:14:10
 
 
À
14/02/2006 16:08:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Divers
Thread ID:
01096307
Message ID:
01096330
Vues:
12
Oh, I know that now. That assumes I know where I have to make the change. I didn't know which field had the problem, nor where it occurred. So, I needed to browse the file (10,000 records or so) to find where the problem was.

>Update! Ignore!
>
>Since you use VFP9, I suggest you try using CAST
>calc cast(sum(field1 / field2) as n(20,5) to lnTotal in otherCursor
>
>>I've just learned it's possible to get stars (****) in a numeric field. I did something like
calc sum(field1 / field2) to lnTotal in otherCursor
>>Select MainCursor
>>Replace Total with lnTotal
>>... and where there are no records in otherCursor, lnTotal gets a lot of stars, and then so does the field .
>>
>>My question: how can I find the records in MainCursor that have stars (instead of numbers) in field Total? Browse for ???????
>>
>>Thanks
Jim Nelson
Newbury Park, CA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform