SELECT Table SCAN FOR Ref = lcRef lnRecNo = RECNO() SCATTER MEMVAR m.Ref = lcNewRef INSERT INTO Table FROM MEMVAR GO lnRecNo ENDSCANExample 2:
SELECT *; FROM Table; WHERE Ref = lcRef; INTO CURSOR Updates SELECT Updates SCAN SCATTER MEMVAR m.Ref = lcNewRef INSERT INTO Table FROM MEMVAR ENDSCANThe reason I'm asking is because "Table" is going to grow rapidly when live and this will be accessed on a Server.