SELECT * FROM ORIGINALTABLE INTO CURSOR C_TEMP READWRITE

REPLACE ALL IDFIELD WITH NEWIDGENERATINGPROGRAM() IN C_TEMP

SELECT ORIGINALTABLE
APPEND FROM DBF("C_TEMP")

repeat for all tables.


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