[Table of Contents] [docx version]
WordprocessingML Reference Material - Table of Contents
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.
|
\b field-argument |
The text in this switch's field-argument specifies which attributes of the format set by the \l switch are to be applied to the table. If the \l switch is blank, the \b switch value shall be 16 (AutoFit). text can have a value that is the bitwise-or of any combination of the following: 0, None 1, Borders 2, Shading 4, Font 8, Color 16, AutoFit 32, Heading Rows 64, Last Row 128, First Column 256, Last Column |
|
\c field-argument |
The text in this switch's field-argument specifies a connection to the data. |
|
\d field-argument |
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. |
|
\f field-argument |
The text in this switch's field-argument specifies the integral record number of the first data record to insert |
|
\h |
Inserts the field names from the database as column headings in the resulting table. |
|
\l field-argument |
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 \b switch doesn't specify the table attributes, an unformatted table is inserted. |
|
\o field-argument |
Inserts data at the beginning of a merge. By adding the \o switch to the database field, it will only get the data for the database field at the beginning of a merge instead of once for each record merged. This is a performance optimization and should only be used when the database field doesn't rely on record specific information to gather. |
|
\s field-argument |
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 (\). |
|
\t field-argument |
The text in this switch's field-argument specifies the integral record number of the last data record to insert. |
[Example: The following field results from a query to a database through ODBC:
{ 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"
end example]