Hi

Can anyone tell me if there is much difference here.

Example 1:

SELECT Table
SCAN FOR Ref = lcRef
     lnRecNo = RECNO()
     SCATTER MEMVAR
     m.Ref = lcNewRef
     INSERT INTO Table FROM MEMVAR
     GO lnRecNo
ENDSCAN

Example 2:

SELECT *;
  FROM Table;
 WHERE Ref = lcRef;
  INTO CURSOR Updates

SELECT Updates
SCAN
     SCATTER MEMVAR
     m.Ref = lcNewRef
     INSERT INTO Table FROM MEMVAR
ENDSCAN

The reason I'm asking is because "Table" is going to grow rapidly when live and this will be accessed on a Server.

What I'm trying to avoid is all the record hopping in the 1st example, but I may be wrong in my 2nd solution, could someone let me know if there's much difference.

Thanks
Kev