Bonjour Fabio,

Thank for help but it work not good.

I think that perhaps impossible with One shot command....?????

UPDATE Resident SET NoitelephoneIdReportActif =  0

UPDATE R SET NoitelephoneIdReportActif =  F.ireport ; && CHOICE WHERE AND WHAT TO UPDATE
      FROM Resident R LEFT JOIN cFiltre F ON F.itelephoneid = R.itelephoneid ; && BUILD THE WORK SET
   WHERE f.ireport = noreport AND F.itelephoneid = R.itelephoneid   && FILTER THE WORK SET

I would like

*-- if the condition is not then replace with 0

UPDATE R SET NoitelephoneIdReportActif = NVL( F.ireport , 0 ) ; && CHOICE WHERE AND WHAT TO UPDATE
FROM Resident R LEFT JOIN cFiltre F ON F.itelephoneid = R.itelephoneid ; && BUILD THE WORK SET
WHERE f.ireport = noreport AND F.itelephoneid = R.itelephoneid && FILTER THE WORK SET



But it do'nt work...





> CURSORSETPROP("Buffering" ,5,"Resident") && WHY YOU USE A BUFFER ?
>
IN foxtalk 2.0 March 2005 Page 15 Tips from the vfp team...

it goes faster ! ( no trigger ).

bernhart