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.)