>I got PT1 with APRINTERS ( )
>
>then I did as below:
>
>DELETE all
>INSERT INTO tablePrinters FROM ARRAY pt1
>
>But:
>
>I dont want to delete all, because I have some fields I have to preserve
>
>I would like to
>
> 1- Append only new printers (not repeated records)
>
> 2- Delete printers that are on the table, but not in the array anymore
>
>TIA
Something like this:
select * from tablePrinters where .f. into cursor tmp readwrite
INSERT INTO tmp FROM ARRAY pt1
delete from tablePrinters where printerName not in (select printerName from tmp)
insert tablePrinters ;
select * from tmp where printerName not in (select printerName from tablePrinters)
Cetin