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


LOL

bernhart

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