>
>Don't work ! Why ?
>

Look your email... ( picture ).


FUNCTION test84()
USE C:\cdbk90\amline\data1\Resident IN 0
USE C:\cdbk90\amline\data1\cFiltre IN 0

NoReport = 19
* UPDATE Resident SET NoitelephoneIdReportActif = 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 && .T. && F.itelephoneid = R.itelephoneid && FILTER THE WORK SET

*!* FULL JOIN amline!Cfiltre ;
*!* ON Resident.iid = Cfiltre.iid

SELECT Resident
* =TABLEUPDATE(.T.)
SET FILTER TO NoitelephoneIdReportActif > 0
BROWSE FIELDS NoitelephoneIdReportActif



ENDFUNC

I have resident.NoitelephoneIdReportActif = 19 BUT i also have resident.NoitelephoneIdReportActif = 6 , 77 ...
and i want for ireport # 19 , i want resident.NoitelephoneIdReportActif = 0

my explanation is it good ?

bernhart


>
>Have you a Resident's trigger ?

In the coverage ===>
*-- Avec buffer clasique
*!* 0.387813,repolist_resident,repolist_resident.lputreportactif,39,c:\cdbk90\amline\libs\acustreport.vct,8
*-- Avec buffer 5 (tableupdate)
*!* 0.116406,repolist_resident,repolist_resident.lputreportactif,43,c:\cdbk90\amline\libs\acustreport.vct,8


>If you have a trigger, it fire when you do the TABLEUPDATE(.T.),
>then: is the complete operation faster ?
>The table buffer overhead slow down the operation by a 4-6X,
>then i'm not sure.