Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding stars
Message
From
14/02/2006 16:14:10
 
 
To
14/02/2006 16:08:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Miscellaneous
Thread ID:
01096307
Message ID:
01096330
Views:
13
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
Previous
Reply
Map
View

Click here to load this message in the networking platform