ActiveX AS/400 Objects - SQLColumn

• ActiveX AS/400 Objects - SQLColumn

• This class contains the properties and values of a single column returned from class:SQL.Execute. Defining a variable as type of SQLColumn is reasonable but not necessary. SQLColumn is available through class:SQL as SQL.Columns.Item(x).

• Contains read/write properties:

 

Name	Type	Description
1CCSIDLocal	Long	Contains Coded Character Set Identifier for local information.
1CCSIDSystem	Long	Contains Coded Character Set Identifier for system information.
1DecimalsLocal	Integer	Contains number of decimals for local numeric information.
1DecimalsSystem	Integer	Contains number of decimals for system numeric information.
1Length	Long	Length of retrieved column in bytes.
Name	String	Name of retrieved column.
1Offset	Long	Positional offset in byte count of column within columns
1PrecisionLocal	Integer	Number of bytes required retaining value as local information.
1PrecisionSystem	Integer	Number of bytes required retaining value as system information.
1TypeEnumLocal	Long	Type of local information.
1TypeEnumSystem	Long	Type of system information.
Value	Variant	Value of column in TypeEnumLocal type.

 

1 These properties are documented here strictly for thoroughness, class:SQL maintains their values automatically.

• VB, VBA SQLColumn example:

See SQL

2003 - Chouinard & Myhre, Inc.