_TALLY System Variable
Contains the number of records processed by the most recently executed table command.
_TALLY = nRecords
Parameters
- nRecords
Contains a numeric value indicating the number of records processed by the most recently executed table command. When you start Visual FoxPro, _TALLY is set to zero (0).
Remarks
Certain table processing commands return information about their status while they execute. When such a command finishes executing, it displays the number of records processed if the SET TALK command is set to ON. If the command is executed against local views and tables, it stores this number to the _TALLY system variable.
The INSERT - SQL command changes _TALLY if a SQL SELECT command is used to specify the data to insert.
The following table lists the commands and functions that return status information and store the number of records processed in _TALLY only when executed against local tables and views.
|
Example
The following example returns the number of U.S. customers from a Customer table using the SQL SELECT command and stores the to _TALLY automatically. The ? command displays the value stored in _TALLY.
SELECT * FROM customer ;
WHERE country = 'USA' ;
INTO CURSOR temp
? _TALLY
For more information, see ? | ?? Command.