添加方法 （ActiveX/CAO）

VBA / VB.NET

RetVal = object.Add(Name, DataType [, Precision] [, Scale])

VBA / VB.NET

RetVal = object.Add(FieldName, Value)

VBA / VB.NET

RetVal = object.Add(DataSource, Catalog, Schema, Table, Name, DisplayAttributes)

VBA / VB.NET

RetVal = object.Add(DataSource, Catalog, Schema, Table, Name, KeyDescriptions)

VBA / VB.NET

RetVal = object.Add(DataSource, Catalog, Schema, Table, Name, SQLText)

类型：按键说明

此方法适用的一个或多个对象。

类型：字符串;仅输入

要添加的列的名称。

类型：CaoDataType 枚举;仅输入

要添加的列的数据类型。指定以下常量之一：

• kCaoTypeText
• kCaoTypeNumeric
• kCaoTypeInteger
• kCaoTypeDouble
• kCaoTypeDate
• kCaoTypeTime
• kCaoTypeTimestamp
• kCaoTypeBit
• kCaoTypeBlob

类型：整数;仅输入;自选

精度的含义取决于指定的数据类型，如下所示：

• kCaoTypeNumeric：数值数据的精度
• kCaoTypeText：以符号为单位的数据长度
• kCaoTypeBlob：以位为单位的数据长度

对于所有其他数据类型，将忽略精度。

类型：整数;仅输入;自选

数字刻度。对于所有其他数据类型，忽略。kCaoTypeNumeric

Type: KeyDescription

The newly added object.

Type: KeyValues

The object or objects this method applies to.

Type: String; input-only

The name of the field to be added.

Type: Variant; input-only

The value of the field being added.

Type: KeyValue

The newly added object.

Type: LabelTemplates

The object or objects this method applies to.

Type: String; input-only

Data source name.

Type: String; input-only

Catalog name.

Type: String; input-only

Schema name.

Type: String; input-only

Table name.

Type: String; input-only

Label template name.

Type: Variant (String or array of strings); input-only

Column names to be displayed as label or format strings. Where a single string is specified, CAO assumes the string is a format string. An array of strings is interpreted as a list of column names.

Format strings are compatible with MText format strings. Refer to database table columns in format strings using the following syntax:

#(<column name>)

For example:

#(name)

Column names are converted to the following format string:

#(<column name 1>\P#(<column name 2>)

Type: LabelTemplate

The newly added object.

Type: LabelTemplates

The object or objects this method applies to.

Type: String; input-only

Data source name.

Type: String; input-only

Catalog name.

Type: String; input-only

Schema name.

Type: String; input-only

Table name.

Type: String; input-only

Link template name.

Type: KeyDescriptions; input-only

Key descriptions for the link template.

Type: LinkTemplate

The newly added object.

Type: Queries

The object or objects this method applies to.

类型：字符串;仅输入

数据源名称。

类型：字符串;仅输入

目录名称。

类型：字符串;仅输入

架构名称。

类型：字符串;仅输入

表名。

类型：字符串;仅输入

链接模板名称。

类型：字符串;仅输入

SQL 语句。

类型：查询

新添加的对象。