DBUSE - Create and/or open a SQL database file

DBUSE Create and/or open a SQL database file

Top Previous Next

Syntax:	DBUSE	[ dbfile \| dsn ] [ /options ]
Arguments:	[ dbfile ]	Variable or string defining a database file name; if no path is defined, Robo-FTP’s working folder is used.
Options:	/new	Create the db file if it does not exist.
	/odbc	Use an odbc data source name instead of a database file

This script command is used to create and/or open a SQL database file. Issue the command with no options to open an existing file.

Add the /new option if the file does not exist and you wish a new file to be created. When a new file is created it is just an empty file - you must still create one or more tables in the database file via the DBQUERY script command before data can be saved to the file.

Or use the /odbc option to specify an ODBC data source instead of using a database file. Windows ODBC data sources are defined in the data sources administrative tool found in the control panel under administrative tools.

Just a single database may be open at any one time.

Related Command(s): DBCLOSE, DBGETRESULTS, DBQUERY