Microsoft KB Archive/135907

= 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.



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.</li>  Type the following commands in the Command window: COPY PROCEDURE TO TEST.TXT APPEND PROCEDURES FROM TEST.TXT </li> When the Warning dialog box displays, choose Add.</li> Edit the Stored Procedures.</li></ol>

The procedures should look something like this: PROCEDURE TEST WAIT WINDOW PROCEDURE TEST WAIT WINDOW

Additional query words: 3.00 VFoxWin

Keywords: KB135907

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.