Database Connection Commands

/UID=<userID>

When using ODBC data sources, the /UID and /PWD can be specified to log into the ODBC databases. The /UID and /PWD are applied to all ODBC databases found. If /UID is provided and /PWD is not, then it is assumed that the /PWD is "". The /UID must be used when /PWD is used.

/PWD=<password>

When using ODBC data sources, the /UID and /PWD can be specified to log into the ODBC databases. The /UID and /PWD are applied to all ODBC databases found. If /PWD is provided the /UID must also be provided.

/D=<path to data file>

Sets or changes the text file database to be used. If no connection to a text file database has been added to the BarTender document, the /D parameter adds it. (BarTender will assume that the first line of the file is a header that contains the field names and that the data fields are delimited with the mixed-quote-and-comma method.) If connections to one or more text file databases have already been added, the file specified with the /D parameter replaces the first text database. (BarTender will assume that the new file uses the same delimitation method as the original file, and it will assume that the first line is a header of field names if and only if the original file had such a header.) The /D parameter applies to all open BarTender documents unless the /AF= parameter has been used. A full path to the database may need to be specified. For more information, refer to How BarTender Processes Path and File Names.

/R=<starting record number>

Starts printing at a specific record in a database. When using a query, the starting record will be used in the results of the query records.

/DbTextHeader=<number of record containing field names>

Identifies the record, if any, containing the field names.

/?<query prompt name>="<query prompt value>"

Assigns a value to the specified query prompt. If there is no match, then the command is ignored. If a query prompt within the document is not set, then the query prompt dialog will be displayed with the remainder of the unset prompts. Multiple query prompts are supported on the command line. Setting query prompts only takes effect when /P, /PD, /FP, or /FPD are specified.

/DD

Causes the deletion of the ASCII data file after the print job if there are one or more databases and the first database is an ASCII database.

/W="<where clause>"

Sets the where clause for record selection within an ODBC database. The where clause will be applied at the time of data browsing or at the time of printing to perform record filtering. The /W option uses the Custom SQL option. If you do not already have a custom SQL statement defined, then one will be generated automatically. The custom SQL statement is parsed for the first occurrence of the WHERE string in your custom SQL statement, and will replace all remaining text with the contents of the <where clause>. If a WHERE clause is not found in your custom SQL statement, then the <where clause> value will be placed at the end of your SQL statement.

BarTender Document Commands • Printing Commands • License Server Commands • Miscellaneous Commands • Command Line Parameter Reference

Open topic with navigation