MODIFY PROCEDURE Command
Opens the Visual FoxPro text editor, making it possible for you to create new stored procedures for the current database, or modify existing stored procedures in the current database.
MODIFY PROCEDURE [NOWAIT]
- Continues program execution after the procedure editor for the current database opens. The program doesn't wait for the editor to close, but continues execution on the program line immediately following the line that contains MODIFY PROCEDURE NOWAIT. Without the NOWAIT clause, MODIFY PROCEDURE opens a procedure editor and program execution pauses until you close the editor.
A database must be open before you can create or modify stored procedures. Stored procedures are typically specified in Delete, Insert, or Update triggers created for a database with CREATE TRIGGER.
Stored procedures in the current database can be executed like other Visual FoxPro procedures in an open procedure file or program. See PROCEDURE for a description of the order and location in which Visual FoxPro searches for procedures.
The following example opens the
testdata database and uses MODIFY PROCEDURE to open the Visual FoxPro text editor, making it possible for you to create new stored procedures or modify existing stored procedures.
CLOSE DATABASES OPEN DATABASE (HOME(2) + 'Data\testdata') MODIFY PROCEDURE && Opens the Visual FoxPro text editor