Returns an array of field (column) names in a table.

Defined in

ODBCConnection

Syntax

fieldArray = odbcConnection.ListFields( [ tableName$ ] )

Parameters

tableName$

String. Optional. The name of the table. Defaults to the current table, if any.

fieldArray

Array of strings. Each element in the array is the name of a field in the referenced table. The entries are in their table order.

Not connected to a data source (DBstsNCON)

Table did not return any columns (DBstsNCOL)

Events

BeforeListFields

AfterListFields

Example
See Also

ListDataSources method
ListTables method

Glossary