ActiveX AS/400 Objects - SQLColumns

• ActiveX AS/400 Objects - SQLColumns

• This class contains the properties and values of a all columns returned from class:SQL.Execute. Defining a variable as type of SQLColumns is reasonable but not necessary. SQLColumns is available through class:SQL as SQL.Columns.

• Contains a read-only property:

 

Name	Type	Description
Count	Long	Number of class:SQLColumn in collection.

 

• Contains methods returning a result:

 

Name	Type	Description
Add	SQLColumn	Creates class:SQLColumn from required name parameter. Returns resulting class:SQLColumn added.
Item	SQLColumn	Returns a class:SQLColumn based on required index parameter. Index can be numeric or name value.

 

• Contains a method:

 

Name	Description
Remove	Removes class:SQLColumn based on required index parameter. Index can be numeric or name value.

 

• VB, VBA SQL example:

See SQL

2003 - Chouinard & Myhre, Inc.