This will only work in a single table circumstance. When you need to get the record numbers of all records that meet the condition you can:
SELECT RECNO() AS rn FROM sometable WHERE condition_is_met

>hey everyone,
>i am trying to select a dbf alias in some code i am writing. what i want it to do after i have selected it is search for a condition in the table and then point to the row where the condition is met. here is what i have so far.
>
>select alias
>scan for column condition = desired condition
>
>what i do not know how to point to the row after the condition is met. can anyone help me with this dilema? thanks.