The cursor may or may not be on disk. If it's smal enough, it will be entirely in memory.

* The Id is the record you want. Note that you may get incorrect results if you use record numbers.
SELECT * FROM tierii_chem WHERE Id = 1424 INTO CURSOR crsTemp 
SELECT <tabletoappendto>
APPEND FROM DBF("crsTemp")

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