ActiveX AS/400 Objects - SQLColumn


 

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.