>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