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