DBCLOSE        Close a SQL database file or connection

<< Click to Display Table of Contents >>

Navigation:  Robo-FTP User's Guide > Script Programming > Script Commands > All Script Commands >

DBCLOSE        Close a SQL database file or connection

Syntax:

DBCLOSE

[ /options ]

Arguments:

None

 

Options:

/delete

Delete the SQLite database file after closing it.

 

 

This script command is used to close a SQLite database file or ODBC database connection previously opened with the DBUSE command. This command also removes any %db_ColumnName variables created by prior execution of the DBGETRESULTS script command.

 

When working with temporary SQLite database files the /delete option is available to delete the file after closing it. This option may not be used to delete a System or User DSN used by an ODBC database connection.

 

 

Related command(s): DBUSE, DBQUERY, DBGETRESULTS, DBREWIND

See also: Using the built-in database engine