PRB: APPEND FROM <File> w/FOR Cause Doesn't Behave As Expected

Article translations Article translations
Article ID: 95664 - View products that this article applies to.
This article was previously published under Q95664
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SYMPTOMS

The APPEND FROM <file> command with a FOR clause appears to fail and behave incorrectly under the following conditions:
  • When SET DELETED is OFF, the APPEND FROM <file> FOR NOT DELETED() command appends all records, including those that have been marked for deletion.
  • If the field referenced in the FOR clause is not in the current database, the APPEND FROM command appends no records, even if there are fields in the original database that meet the FOR condition.

CAUSE

This behavior occurs because the APPEND FROM command evaluates the criteria after it has been copied from the database.
  • In the first instance, the deleted attribute is not valid in this state and therefore all deleted records are copied. If SET DELETED is ON, the APPEND FROM command automatically ignores all deleted records.
  • In the second case, the APPEND FROM command tries to copy all the fields and then delete the fields that do not match the FOR clause. Since the field does not exist in the current database, the condition cannot be met, and the APPEND FROM command fails.

WORKAROUND

To work around this problem, use the COPY TO command as follows:
COPY TO <file> FOR NOT DELETED()

-or-

COPY TO <file> FOR <field> = <value>

Properties

Article ID: 95664 - Last Review: February 27, 2014 - Revision: 2.1
APPLIES TO
  • Microsoft Visual FoxPro 3.0 Standard Edition
  • Microsoft FoxPro 2.5b
  • Microsoft FoxPro 2.5a
  • Microsoft FoxPro 2.5b
  • Microsoft FoxPro 2.6 Standard Edition
  • Microsoft FoxPro 2.0
  • Microsoft FoxPro 2.5b for MS-DOS
  • Microsoft FoxPro 2.5a
  • Microsoft FoxPro 2.5b for MS-DOS
  • Microsoft FoxPro 2.6 for MS-DOS
  • Microsoft FoxPro 2.5b for Macintosh
  • Microsoft Visual FoxPro 2.5c for Macintosh
Keywords: 
kbnosurvey kbarchive KB95664

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com