LOCATE for "*" $ str(fieldinquestion)
works just fine. Thanks
Jim
>>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
>
>There are a couple of ways to get *** in a numeric field... the term is "numeric overflow". One way to get it is to divide by zero. The other is to calculate a figure and the solution exceeds the number of digits in the field (e.g. 99 will not "fit" into a N1.0 field... it will result in ***).
>
>I suspect that you *don't* have stars in your source data... I think you have it as a result of divisions by zero. But, if you do have to look for stars you can either look up at the sky at night *or* :
>
>>LOCATE for str(fieldinquestion)="***"
>
>*Regards*
>Ed
Jim Nelson
Newbury Park, CA