odbc_databaseGetColumnNames()

Synopsis

Returns a list of column names in the table.

Syntax

odbc_databaseGetColumnNames ( db_pointer As User, _
                              catalog As String, _
                              schema As String, _
                              table As String, _
                              Optional ignoreErrors? As Boolean = False ) As List

Argument	Type	Description
db_pointer	user	Database reference. This reference should be obtained with the previous call to odbc_databaseOpen
catalog	string	Catalog name
schema	string	Schema name
table	string	Table/View name
ignoreErrors?	boolean	Optional; if the argument is True , then database errors are not reported as Intent exceptions; default is False .

Example 1

Enumerates the fields/columns in the table of the database

Dim db As User = odbc_databaseOpen( "ODBC;DSN=PEFRESULTS") 
Dim catalogues As List = odbc_databaseGetCatalogNames( db) 
Dim columns As List = odbc_databaseGetColumnNames( db, First(catalogues), "", "Customer") 
odbc_databaseClose( db)
Return columns

--> {"CustomerName", "IDName"}