>>>Is there a way to add an incremental count expression while using SELECT statement. For example, the statement below retrieves record into cursor:
>>>
>>>

>>>select firstname from sometable into cursor
>>>

>>>
>>>the data retrieved is;
>>>

>>>john
>>>susan
>>>mary
>>>etc..
>>>

>>>
>>>Is there a way to write the SELECT statement where I can add a number for each record retrieved. For example:
>>>
>>>the desired data I would like to retreive is the firstname column and incremental number column (I don't know how to add something in SELECT statement to create incremental numbers);
>>>

>>>name column    incremental number column
>>>john           1
>>>susan          2
>>>mary           3
>>>etc..          etc..
>>>

>>>
>>>is there anything I can add in the SELECT statment to get incremental number column. Thanks
>>>
>>>Nick
>>
>>I don't think so. But even if you could, I suggest that you do that in a second run.

>>select firstname,00000 as counter from sometable into cursor readwrite
>>replace all counter with recno()

>
>thanks for the suggestion Tore, couldn't escape the second run. Thanx again.
>
>Nick

You're welcome. Please forgive my ignorance, but what do you mean by "couldn't escape the second run"?