>You have to:
>
>Select < FieldList > from < TableName > where < Condition > into cursor TempCursor readwrite nofilter
>
>Select * ... here you use * as the field list to indicate all fields.
>
>Select field1, field2 from ... or specify the fields
>
>... where between(recno(), 1424, 1450) ... I don't know if I've tried this type of statement. I guess it would work. You're using the VFP RECNO() and BETWEEN functions. Check help on those. Or you could use a more sophisticated where clause.
>
>readwrite and nofilter are optional here.
>
While these are optional clauses for many queries you should include the READWRITE clause in your query. At least two reasons.

1. You may have to modify your primary key field to ensure uniqueness before you append into the target table.

2 More important.......you may have a result that is a filtered data set. As I was reminded in a recent discussion about RECCOUNT() and _TALLY, the DBF() behind your resulting query could be the entire database. READWRITE will prevent that.





>After you get TempCursor, then you're good to go with Sergey's #2 solution.
>
>
>>Alright I am trying the second method.
>>
>>I am doing:
>>
>>SELECT 1424 FROM tierii_chem INTO CURSOR crstemp
>>
>>The first record number is 1424. Am I missing something in this step?
>>
>>And where does the temporary cursor go?