United States (English)

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

@ ... CLASS Command

@ ... CLEAR Command

@ ... FILL Command

@ ... SCROLL 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 FROM ARRAY Command

APPEND FROM Command

APPEND GENERAL Command

APPEND MEMO Command

APPEND PROCEDURES Command

AVERAGE Command

BEGIN TRANSACTION Command

BLANK Command

BUILD APP Command

BUILD DLL Command

BUILD EXE Command

BUILD MTDLL Command

BUILD PROJECT Command

CALCULATE Command

CD | CHDIR Command

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

EXTERNAL Command

FLUSH Command

FOR EACH ... ENDFOR Command

FOR ... ENDFOR Command

FREE TABLE Command

FUNCTION Command

GETEXPR Command

GO | GOTO Command

HELP Command

HIDE MENU Command

HIDE POPUP Command

HIDE WINDOW Command

IF ... ENDIF Command

INSERT - SQL 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

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

PUSH KEY Command

PUSH MENU Command

PUSH POPUP Command

QUIT Command

RD | RMDIR Command

READ Command

READ EVENTS 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 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

RETRY Command

ROLLBACK Command

RUN | ! Command

SAVE MACROS Command

SAVE SCREEN Command

SAVE TO Command

SAVE WINDOWS Command

SCAN ... ENDSCAN Command

SCATTER Command

SEEK Command

SELECT - SQL 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

UPDATE - SQL Command

USE Command

VALIDATE DATABASE Command

WAIT Command

WITH ... ENDWITH Command

ZAP Command

ZOOM WINDOW Command

Minimize

This topic has not yet been rated - Rate this topic

DELETE CONNECTION Command

Visual Studio 2005

Visual Studio .NET 2003

Deletes a named connection from the current database.


DELETE CONNECTION ConnectionName

Parameters

ConnectionName: Specifies the name of the named connection to delete from the current database.

Deleting a named connection definition does not close any active connections.

DELETE CONNECTION requires exclusive use of the database. To open a database for exclusive use, include EXCLUSIVE in OPEN DATABASE.

The following example assumes an ODBC data source called MyFoxSQLNT is available. The testdata database is opened, and a connection named Myconn is created. DISPLAY CONNECTIONS is used to display the named connections in the database. The connection is then removed from the database with DELETE CONNECTION.

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

CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "<userid>" PASSWORD "<password>"
DISPLAY CONNECTIONS    && Displays named connections in the database
DELETE CONNECTION Myconn  && Removes the connection just created

Reference

CREATE CONNECTION Command
MODIFY CONNECTION Command
RENAME CONNECTION Command

Other Resources

Commands (Visual FoxPro)
Language Reference (Visual FoxPro)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.