>>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