Perhaps VFP doesn't like "traiters"? <g>

Seriously, with a GROUP BY, every field must be either a criterion for the GROUP BY clause, or have a sum(), avg(), max(), etc., applied to it. Otherwise, VFP doesn't know, when grouping several records, from which record to select the data, and this is what provokes the error message in newer versions.

>Hi all,
>
>
>Here is my command.
>
>

>
>SET ENGINEBEHAVIOR 90
>
>UPDATE AgendaPhar;
>    SET ltransfert = ;
>    NVL( ( SELECT E.ltransfert ;
>    FROM  Traiter T INNER JOIN Etats E ON  T.Iresidentid = E.Iresidentid AND T.iid = AgendaPhar.itraiterId;
>    INNER JOIN DatesFiltred D ON D.ddate BETW E.ddebut  AND EVL( E.dfin , vp_date );
>    WHERE E.ltransfert = .T. ) , .F. )
>

>
>I want that my subquery is single.( one record )
>
>If i try a Group by claus , it is not possible ...
>What can i do ?
>
>
>
>Thank in advance
>
>bernhart