>>>How do Determine if a cursor is empty after doing select statement. The following is not working:
>>>
>>>

>>>			Select crsprod, crsitemcode, sum(crsrequestamt) as inreq, sum(crsaccptamt) as whsaccpt, crsdelivertype, Count(*) as duplicate From crs_grid1 ;
>>>			  	Group By  crsprod, crsitemcode, crsdelivertype HAVING duplicate > 1 AND crsdelivertype > 1 INTO CURSOR crs_find_dup
>>>			IF isnull('crs_find_dup')
>>>				MESSAGEBOX('empty cursor',0,'')
>>>			ELSE
>>>				MESSAGEBOX('not empty cursor',0,'')
>>>			ENDIF 	
>>>

>>>
>>>thanks
>>>Nick
>>
>>After your SELECT, check _TALLY=0.
>
>thanks Fred, that worked.
>
>Nick
PMFJI, Nick,

That may not work in vfp9, because _tally returns a 1 because of the sum().
You may need to do something like this in vfp 9:

  SELECT SUM(capacity) AS capacity ;
    FROM cVehCap ;
    WHERE loadtype == lcType ;
    INTO ARRAY latmp1
  IF !ISNULL(latmp1) AND !EMPTY(latmp1)