>SELECT ptTemp > SCAN > SELECT tPrinters > LOCATE FOR ALLTRIM(UPPER(tPrinters.nome)) = ALLTRIM(UPPER(ptTemp.nome)) > IF NOT FOUND () > > APPEND BLANK > replace tprinters.nome WITH ptTemp.nome > replace tprinters.porta WITH ptTemp.porta > replace tprinters.driver WITH ptTemp.driver > > ENDIF > ENDSCAN > > >*******************DELETE METHOD******************************************************** > **** if a record from tPrinters does not exist in ptTemp, deletes it from ptTemp > > SELECT tPrinters > SCAN > SELECT ptTemp > LOCATE FOR ALLTRIM(UPPER(ptTemp.nome)) = ALLTRIM(UPPER(tPrinters.nome)) > IF NOT FOUND () * You need to switch back to your original table > DELETE in tPrinters > ENDIF > ENDSCAN > >SET EXACT OFFSee correction inside.
DELETE tPrinters from tPrinters LEFT JOIN ptTemp T on UPPER(tPrinters.ptTemp.Nome) = UPPER(T.nome) where T.Nome is NULL