Knowledge Base

PRB: APPEND PROCEDURES Command Generates a Warning

Article ID: 135907

Article Last Modified on 2/15/2000

APPLIES TO

Microsoft Visual FoxPro 3.0 Standard Edition

This article was previously published under Q135907

SYMPTOMS

Using the APPEND PROCEDURES command to add more procedures to a database's Stored Procedures may generate a Warning:

WARNING: The Procedures contain compile errors.
Would you like to add them anyway?

CAUSE

This happens when the last line in the Stored Procedure file is missing a carriage return or the appending text file doesn't start with a carriage return. As a result, two lines are combined into one, which generates a warning message.

RESOLUTION

Make sure a carriage return is at the end of the Stored Procedures and that the appending file starts with a carriage return. For example, use this code:

   procfile = '_'+SUBSTR((SYS(3),1,7)+".TXT"
   fchnl = FCREATE((procfile))
   =FPUTS(fchnl,"")
   =FCLOSE(fchnl)
   COPY PROCEDURES TO (procfile) ADDITIVE

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new Database.
Edit the Stored Procedures.
Enter the following information into the Stored Procedures:
```
   PROCEDURE TEST
   WAIT WINDOW
```
Make sure there is no carriage return after the WAIT WINDOW command.
Close the Stored Procedures.

Type the following commands in the Command window:

   COPY PROCEDURE TO TEST.TXT
   APPEND PROCEDURES FROM TEST.TXT

When the Warning dialog box displays, choose Add.
Edit the Stored Procedures.

The procedures should look something like this:

   PROCEDURE TEST
   WAIT WINDOW PROCEDURE TEST
   WAIT WINDOW

Additional query words: 3.00 VFoxWin

Keywords: KB135907