CFINSERT

Inserts new records in ODBC data sources.

CFINSERT
Attribute

Description

DATASOURCE

Required. Name of the ODBC data source that contains your table.

TABLENAME

Required. Name of the table you want the form fields inserted to.

TABLEOWNER

Optional. For data sources that support table ownership (e.g., SQL Server, Oracle, and Watcom SQL), use this field to specify the owner of the table.

TABLEQUALIFIER

Optional. For data sources that support table qualifiers, use this field to specify the qualifier for the table. The purpose of table qualifiers varies across drivers. For SQL Server and Oracle, the qualifier refers to the name of the database that contains the table. For the Intersolv dBase driver, the qualifier refers to the directory where the DBF files are located.

FORMFIELDS

Optional. A comma-separated list of form fields to insert. If this attribute is not specified, all fields in the form are included in the operation.

Examples

<CFINSERT DATASOURCE="Coffee Valley" TableName="Visitor">