>>>Why would you want to do that when there is recno()? Why don't you suggest, is there a reason? Even if one wouldn't use recno() because of something like indexed view along with 1,2...100 numbering then why would you ever want to add to source another column, you could use an auxillary cursor or array.
>>>Cetin
>>
>>With deleted records recno() is not necessary 1,2,3 etc. I'm not sure how to use auxillary array (based on recno() or ID, I assume) and would it be faster or not than the actual RowNum column.
>
>An auxillary array can be based on any order and simply keeps ID. Ascan() returns 'recno'. It is simple and fast (posted sample a few times before). I don't know something called RowNum column.
>Cetin
Yes, I figured that. I think you're right, it may be better alternative.
If it's not broken, fix it until it is.
My Blog