How to determine the number of records that are returned by a SELECT-SQL statement in Visual FoxPro

MORE INFORMATION

   * 
   *
   SET STATUS OFF && SET STATUS BAR OFF in FoxPro for Windows
   fyl = GETFILE('DBF','Choose a table:')
   USE (fyl)
   LIST STRUCTURE
   USE
   ACCEPT 'Enter field list, separated by commas (or ENTER for all):' ;
      TO flds
   IF EMPTY(flds)
      flds='*'
   ENDIF
   ?
   ACCEPT 'Enter conditions (or ENTER for none) ' TO cond
   IF EMPTY(cond)
      cond=''
   ELSE
      cond='WHERE '+cond
   ENDIF

   SELECT &flds FROM (fyl) &cond INTO CURSOR query NOCONSOLE

   IF _TALLY>0
      BROWSE
   ELSE
      WAIT WINDOW 'No matching records found...'
   ENDIF