Partager via

_TALLY System Variable

  • Article

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.

APPEND FROM Command

REINDEX Command

AVERAGE Command

REPLACE Command

CALCULATE Command

REQUERY( ) Function

COPY TO Command

SELECT - SQL Command

COUNT Command

SUM Command

DELETE Command

SORT Command

DELETE - SQL Command

TOTAL Command

INDEX Command

UPDATE Command

INSERT - SQL Command (Used with SELECT)

UPDATE – SQL Command

PACK Command

 

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.

See Also

Reference

SET TALK Command

System Variables

Other Resources

Language Reference (Visual FoxPro)