Command Line Syntax
The syntax for running the Database Viewer from the command line is as follows:
DBVIEWER [/nogui] [/edit] "title=<title>" "user=<username>" "pwd=<password>" "ODBC=<data source name>" "sql=<sql statement>" ["template=<template filename>"] [report=<report filename>]
where:
/nogui Hides the console interface to automatically export HTML. Use this switch if you want to hide the Database Viewer interface and if you are also specifying template filename and report filename parameters.
/edit Enables users to edit the data displayed in the Viewer, and to update the Site database.
<title> Specifies the text for the title bar of the Database Viewer.
<username> The user name required to access the database.
<password> The password required to access the database.
<data source name> The Data Source Name (DSN) which Vector AM uses to access the database.
<sql statement> The SQL (Structured Query Language) statement, which specifies the data to be displayed in the Database Viewer. Alternatively, you can reference an external text file (with a file extension of .SQL) containing your SQL select statement.
<template> The name of the HTML template file for the HTML report.
<report> The name of the generated HTML report file.
Notes
When
passing a SQL statement parameter from the command line or from a batch file, you must use two percentage
characters (%%) in place of a single percentage character. (This does not apply when opening the Database
Viewer from the Run command in the Start menu, when running it from a Command Launch operation,
or when editing the SQL details from within the Database Viewer.)
We
recommend you use <title> parameters to avoid confusion when viewing data.
Related Topics