>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