>Hi all,
>
>I have resident.dbf
>iid
>Cname
>NoitelephoneIdReportActif
>itelephoneid
>
>cFiltre.dbf
>iid
>itelephoneid
>ireport
>
>I want replace in resident.dbf the field "Resident.NoitelephoneIdReportActif " WITH cFiltre.ireport
>if resident.itelephoneid = cFiltre.itelephoneid and if not 0 ( zero ).
>
>I try this but it is not good....
>I want one shot command
>
>
>

>
>  CURSORSETPROP("Buffering" ,5,"Resident")
>
>*-- ICASE( F.ireport = NoReport AND  F.lactif = .T. AND  F.ireport = NoReport , F.ireport , 0 );
>
>  UPDATE Resident SET NoitelephoneIdReportActif =  F.ireport ;
>      FROM cFiltre F ;
>    WHERE F.itelephoneid = Resident.itelephoneid
>
>
>  SELECT Resident
>  =TABLEUPDATE(.T.)
>
>

  CURSORSETPROP("Buffering" ,5,"Resident") && WHY YOU USE A BUFFER ? 

*-- ICASE( F.ireport = NoReport AND  F.lactif = .T. AND  F.ireport = NoReport , F.ireport , 0 );

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

  SELECT Resident
  =TABLEUPDATE(.T.)