Thank Mike.

It is very kind of you.

bernhart


>I think you should always avoid using RECNO() in a SQL. I think COUNT(*) is what you need.
>
> >Thank borislav
>>
>> SELECT COUNT( RECNO() ) , 'Résidants Présents dont :' FROM (AMLINE!Resident AS 'R';
>> LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid ) WHERE ;
>> ISNULL( e.iid )= .F. AND e.ltransfert= .F. AND e.dfin <> {} AND TTOD( r.dsortie ) = {} AND;
>> e.iid IN ( SELECT MAX( B.iid ) FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = e.iresidentid ) INTO CURSOR TEMP1
>>
>>
>>
>>>Remove ORDER BY in Your SubQuery:
>>>
>>>

>>>SET ENGINEBEHAVIOR 80
>>>SELECT COUNT( RECNO() ),;
>>>       e.iid FROM (AMLINE!Resident AS 'R';
>>> LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid );
>>> WHERE e.iid IN ( SELECT B.iid FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = E.iresidentId GROUP BY B.iid)
>>>

>>>
>>>
>>>>Hi all,
>>>>
>>>>I have a error 1300 in my sql command.
>>>>Function name is missing
>>>>
>>>>
>>>>I do'nt see what happend..
>>>>5VFP 8.1 SET BEHA 80
>>>>

>>>>
>>>>SET ENGINEBEHAVIOR 80
>>>> SELECT COUNT( RECNO() )  , e.iid FROM (AMLINE!Resident AS 'R';
>>>>    LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid ) WHERE ;
>>>>    e.iid IN ( SELECT B.iid FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = E.iresidentId GROUP BY B.iid ORDER BY B.iid )
>>>>

>>>>
>>>>
>>>>Thank in advance for help
>>>>
>>>>bernhart