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?