PRB: _Tally System Variable Reports Incorrect Record Count (161146)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft Visual FoxPro for Windows 3.0b
- Microsoft Visual FoxPro for Windows 5.0
- Microsoft Visual FoxPro for Windows 6.0
This article was previously published under Q161146 SYMPTOMS
When using a SEEK command in the FOR clause of the APPEND FROM command, the
_TALLY system variable does not reflect the additional records added to a
table.
CAUSE
The SEEK command is moving the record pointer in the table while the APPEND
FROM command is adding records. This prevents the _TALLY from returning the
proper count.
RESOLUTION
Place the SEEK command, or any other command that may move the record
pointer, outside of the APPEND FROM command. Use a FOR...NEXT or an
IF...ENDIF loop structure to process and limit the records.
REFERENCES
For more information about updating master and transaction tables, please
see the following articles in the Microsoft Knowledge Base:
98355
How to Update a Master File from a Transaction File
Modification Type: | Major | Last Reviewed: | 12/3/2003 |
---|
Keywords: | KB161146 |
---|
|