DATABASE
Syntax:
DATABASE [ switches ]
Description: Inserts the results of a database query into a WordprocessingML table. If the number of columns is 62 or more, the field inserts the results of a query in columns separated by tabs. The DATABASE field contains all the information needed to connect to a database and perform an SQL query. Each time the field is updated, the database is queried again.
Field Value: The results of a database query as a WordprocessingML table.
Switches: Zero or more of the following field-specific-switches.
|
The text in this switch's field-argument specifies which attributes of the format set by the 0, None 1, Borders 2, Shading 4, Font 8, Color 16, AutoFit 32, Heading Rows 64, Last Row 128, First Column 256, Last Column |
---|---|
|
The text in this switch's field-argument specifies a connection to the data. |
|
The text in this switch's field-argument specifies the complete path and file name of the database. Used for all database queries except a query to an SQL database table using ODBC. |
|
The text in this switch's field-argument specifies the integral record number of the first data record to insert |
|
Inserts the field names from the database as column headings in the resulting table. |
|
The text in this switch's field-argument specifies the format that is to be applied to the result of the database query. If this switch is used and the |
|
Inserts data at the beginning of a merge. By adding the |
|
The text in this switch's field-argument specifies a set of SQL instructions. Each quotation mark in the instructions shall be preceded by a backslash (\). |
|
The text in this switch's field-argument specifies the integral record number of the last data record to insert. |
{ DATABASE \d "C:\\Data\\Sales93.mdb" \c "DSN=MS Access Database; DBQ=C:\\Data\\Sales93.mdb; FIL=RedISAM" \s "select * from \"Customer List\"" \f "2445" \t "2486" \l "2"