Given a table with a simple 10 character key (lets call it member_id) stored as a typical key in a CDX, guess which is faster:

Assume we have an memvar called cDesiredID

Select Recno() as RecNum, Field1, Field2, etc from MyTable into Cursor MyCursor Where Member_ID = cDesiredID

compared to:

Seek cDesiredID
RecNoSave=Recno()
Copy to Array MyArray Fields AnyField, Field1,Field2, etc While Member_ID=cDesiredID
GoTo RecNoSave
For I=1 to _Tally
MyArray(i,1)=RecnoI()
Skip
EndFor
Use Mycursor
Zap
Append From Array MyArray

Result: The second method, surprising to me, is much, much faster when MyCursor contains only a few (less than a dozen) records. I haven't tested it with more (not necessary in my app).