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