FieldDatabase class

FieldDatabase class

Implements the DATABASE field. To learn more, visit the Working with Fields documentation article.

Remarks

Inserts the results of a database query into a WordprocessingML table.

Inheritance: FieldDatabaseField

Constructors

NameDescription
FieldDatabase()The default constructor.

Properties

NameDescription
connectionGets or sets a connection to the data.
display_resultGets the text that represents the displayed field result.
(Inherited from Field)
endGets the node that represents the field end.
(Inherited from Field)
file_nameGets or sets the complete path and file name of the database
first_recordGets or sets the integral record number of the first data record to insert.
formatGets a FieldFormat object that provides typed access to field’s formatting.
(Inherited from Field)
format_attributesGets or sets which attributes of the format are to be applied to the table.
insert_headingsGets or sets whether to insert the field names from the database as column headings in the resulting table.
insert_once_on_mail_mergeGets or sets whether to insert data at the beginning of a merge.
is_dirtyGets or sets whether the current result of the field is no longer correct (stale) due to other modifications made to the document.
(Inherited from Field)
is_lockedGets or sets whether the field is locked (should not recalculate its result).
(Inherited from Field)
last_recordGets or sets the integral record number of the last data record to insert.
locale_idGets or sets the LCID of the field.
(Inherited from Field)
queryGets or sets a set of SQL instructions that query the database.
resultGets or sets text that is between the field separator and field end.
(Inherited from Field)
separatorGets the node that represents the field separator. Can be None.
(Inherited from Field)
startGets the node that represents the start of the field.
(Inherited from Field)
table_formatGets or sets the format that is to be applied to the result of the database query.
typeGets the Microsoft Word field type.
(Inherited from Field)

Methods

NameDescription
get_field_code()Returns text between field start and field separator (or field end if there is no separator). Both field code and field result of child fields are included.
(Inherited from Field)
get_field_code(include_child_field_codes)Returns text between field start and field separator (or field end if there is no separator).
(Inherited from Field)
remove()Removes the field from the document. Returns a node right after the field. If the field’s end is the last child of its parent node, returns its parent paragraph. If the field is already removed, returns None.
(Inherited from Field)
unlink()Performs the field unlink.
(Inherited from Field)
update()Performs the field update. Throws if the field is being updated already.
(Inherited from Field)
update(ignore_merge_format)Performs a field update. Throws if the field is being updated already.
(Inherited from Field)

See Also