Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual FoxPro
Visual FoxPro 9.0 SP2
Microsoft Visual FoxPro 9.0 SP2
Reference
Language Reference
Commands
& Command
&& Command
* Command
? | ?? Command
??? Command
@ ... CLASS Command
@ ... CLEAR Command
@ ... FILL Command
@ ... SCROLL Command
\ | \\ Command
= Command
ACTIVATE MENU Command
ACTIVATE POPUP Command
ACTIVATE SCREEN Command
ACTIVATE WINDOW Command
ADD CLASS Command
ADD TABLE Command
ALTER TABLE - SQL Command
APPEND Command
APPEND FROM ARRAY Command
APPEND FROM Command
APPEND GENERAL Command
APPEND MEMO Command
APPEND PROCEDURES Command
ASSERT Command
AVERAGE Command
BEGIN TRANSACTION Command
BLANK Command
BROWSE Command
BUILD APP Command
BUILD DLL Command
BUILD EXE Command
BUILD MTDLL Command
BUILD PROJECT Command
CALCULATE Command
CANCEL Command
CD | CHDIR Command
CHANGE Command
CLEAR Commands
CLOSE Commands
CLOSE MEMO Command
COMPILE Command
CONTINUE Command
COPY FILE Command
COPY INDEXES Command
COPY MEMO Command
COPY PROCEDURES Command
COPY STRUCTURE Command
COPY STRUCTURE EXTENDED Command
COPY TAG Command
COPY TO ARRAY Command
COPY TO Command
COUNT Command
CREATE CLASS Command
CREATE CLASSLIB Command
CREATE COLOR SET Command
CREATE Command
CREATE CONNECTION Command
CREATE CURSOR - SQL Command
CREATE DATABASE Command
CREATE FORM Command
CREATE FROM Command
CREATE LABEL Command
CREATE MENU Command
CREATE PROJECT Command
CREATE QUERY Command
CREATE REPORT - Quick Report Command
CREATE REPORT Command
CREATE SQL VIEW Command
CREATE TABLE - SQL Command
CREATE TRIGGER Command
CREATE VIEW Command
DEACTIVATE MENU Command
DEACTIVATE POPUP Command
DEACTIVATE WINDOW Command
DEBUG Command
DEBUGOUT Command
DECLARE - DLL Command
DECLARE Command
DEFINE BAR Command
DEFINE CLASS Command
DEFINE MENU Command
DEFINE PAD Command
DEFINE POPUP Command
DEFINE WINDOW Command
DELETE - SQL Command
DELETE Command
DELETE CONNECTION Command
DELETE DATABASE Command
DELETE FILE Command
DELETE TAG Command
DELETE TRIGGER Command
DELETE VIEW Command
DIMENSION Command
DIR or DIRECTORY Command
DISPLAY Command
DISPLAY CONNECTIONS Command
DISPLAY DATABASE Command
DISPLAY DLLS Command
DISPLAY FILES Command
DISPLAY MEMORY Command
DISPLAY OBJECTS Command
DISPLAY PROCEDURES Command
DISPLAY STATUS Command
DISPLAY STRUCTURE Command
DISPLAY TABLES Command
DISPLAY VIEWS Command
DO CASE ... ENDCASE Command
DO Command
DO FORM Command
DO WHILE ... ENDDO Command
DOCK Command
DOEVENTS Command
DROP TABLE Command
DROP VIEW Command
EDIT Command
EJECT Command
EJECT PAGE Command
END TRANSACTION Command
ERASE Command
ERROR Command
EXIT Command
EXPORT Command
EXTERNAL Command
FLUSH Command
FOR EACH ... ENDFOR Command
FOR ... ENDFOR Command
FREE TABLE Command
FUNCTION Command
GATHER Command
GETEXPR Command
GO | GOTO Command
HELP Command
HIDE MENU Command
HIDE POPUP Command
HIDE WINDOW Command
IF ... ENDIF Command
INSERT - SQL Command
IMPORT Command
INDEX Command
KEYBOARD Command
LABEL Command
LIST Commands
LIST CONNECTIONS Command
LIST DATABASE Command
LIST DLLS Command
LIST OBJECTS Command
LIST PROCEDURES Command
LIST TABLES Command
LIST VIEWS Command
LOCAL Command
LOCATE Command
LOOP Command
LPARAMETERS Command
MD | MKDIR Command
MENU Command
MODIFY CLASS Command
MODIFY COMMAND Command
MODIFY CONNECTION Command
MODIFY DATABASE Command
MODIFY FILE Command
MODIFY FORM Command
MODIFY GENERAL Command
MODIFY LABEL Command
MODIFY MEMO Command
MODIFY MENU Command
MODIFY PROCEDURE Command
MODIFY PROJECT Command
MODIFY QUERY Command
MODIFY REPORT Command
MODIFY STRUCTURE Command
MODIFY VIEW Command
MODIFY WINDOW Command
MOUSE Command
MOVE POPUP Command
MOVE WINDOW Command
NODEFAULT Command
NOTE Command
ON BAR Command
ON ERROR Command
ON ESCAPE Command
ON EXIT BAR Command
ON EXIT MENU Command
ON EXIT PAD Command
ON EXIT POPUP Command
ON KEY LABEL Command
ON PAD Command
ON PAGE Command
ON SELECTION BAR Command
ON SELECTION MENU Command
ON SELECTION PAD Command
ON SELECTION POPUP Command
ON SHUTDOWN Command
OPEN DATABASE Command
PACK Command
PACK DATABASE Command
PARAMETERS Command
PLAY MACRO Command
POP KEY Command
POP MENU Command
POP POPUP Command
PRINTJOB ... ENDPRINTJOB Command
PRIVATE Command
PROCEDURE Command
PUBLIC Command
PUSH KEY Command
PUSH MENU Command
PUSH POPUP Command
QUIT Command
RD | RMDIR Command
READ Command
READ EVENTS Command
RECALL Command
REINDEX Command
RELEASE BAR Command
RELEASE CLASSLIB Command
RELEASE Command
RELEASE LIBRARY Command
RELEASE MENUS Command
RELEASE PAD Command
RELEASE POPUPS Command
RELEASE PROCEDURE Command
RELEASE WINDOWS Command
REMOVE CLASS Command
REMOVE TABLE Command
RENAME CLASS Command
RENAME Command
RENAME CONNECTION Command
RENAME TABLE Command
RENAME VIEW Command
REPLACE Command
REPLACE FROM ARRAY Command
REPORT FORM Command
RESTORE FROM Command
RESTORE MACROS Command
RESTORE SCREEN Command
RESTORE WINDOW Command
RESUME Command
RETRY Command
RETURN Command
ROLLBACK Command
RUN | ! Command
SAVE MACROS Command
SAVE SCREEN Command
SAVE TO Command
SAVE WINDOWS Command
SCAN ... ENDSCAN Command
SCATTER Command
SCROLL Command
SEEK Command
SELECT - SQL Command
SELECT Command
SET Command Overview
SHOW MENU Command
SHOW POPUP Command
SHOW WINDOW Command
SIZE POPUP Command
SIZE WINDOW Command
SKIP Command
SORT Command
STORE Command
SUM Command
SUSPEND Command
TEXT ... ENDTEXT Command
TOTAL Command
TRY...CATCH...FINALLY Command
TYPE Command
UNLOCK Command
UPDATE - SQL Command
USE Command
VALIDATE DATABASE Command
WAIT Command
WITH ... ENDWITH Command
ZAP Command
ZOOM WINDOW Command
Expand Minimize
This topic has not yet been rated - Rate this topic

LIST PROCEDURES Command

Visual Studio 2005

Continuously displays the names of stored procedures in the current database.

Copy 

LIST PROCEDURES   [TO PRINTER [PROMPT] | TO FILE FileName [ADDITIVE]]   [NOCONSOLE]

Parameters

TO PRINTER [PROMPT]

Directs the information returned from LIST PROCEDURES to a printer.

You can include PROMPT to display a Print dialog box before printing starts. Place the PROMPT keyword immediately after TO PRINTER.

TO FILE FileName

Directs output from LIST PROCEDURES to the disk file specified with FileName. If the file already exists and SET SAFETY is ON, Visual FoxPro displays a prompt asking if you want to overwrite the file.

ADDITIVE

Appends to the end of the named file. If you omit ADDITIVE, then the file is overwritten with the value of the expression.

NOCONSOLE

Suppresses output to the main Visual FoxPro window or to the active user-defined window.

Stored procedures are created with MODIFY PROCEDURES.

The following example opens the testdata database and uses LIST PROCEDURES to list the stored procedures (if any) in the database.

Copy 
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'data\testdata')

CLEAR
LIST PROCEDURES  && Lists stored procedures in the database
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.