Export (0) Print
Expand All
Expand Minimize

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]

Parameters

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 Command 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

Community Additions

ADD
Show:
© 2014 Microsoft