>SET RESOURCE OFF >SELECT 0 >USE foxuser EXCL >DELETE ALL FOR id = "REPORTTOOLS" >DELETE ALL FOR id = "TTOOLBAR" >PACK >APPEND FROM holdrpt.dbf >SET RESOURCE ON ><PRE> >Thanks I'm not sure, but we do it differently: <PRE> USE SYS(2005) AGAIN IN 0 ALIAS resource USE repoinit IN 0 SELECT repoinit LOCAL ari[1] SCAN ALL SCATTER MEMO TO ari UPDATE resource ; SET type=repoinit.type, ; id=repoinit.id, ; name=repoinit.name, ; readonly=repoinit.readonly, ; ckval=repoinit.ckval, ; data=repoinit.data, ; updated=repoinit.updated ; WHERE id=repoinit.id ; AND name=repoinit.name IF _TALLY=0 INSERT INTO resource FROM ARRAY ari ENDIF ENDSCAN USE IN repoinit USE IN resource FLUSH