Procedure TestDatabaseTable(Datasource, Tablename)

TestDatabaseTable

With the procedure TestDatabaseTable you can check whether a given table name exists in a specific data source.

TestDatabaseTable(
     Datasource,         ! (input) a string expression
     Tablename           ! (input) a string expression
     )

Arguments

Datasource

A string containing the name of a data source.

Tablename

A string containing the name of a table in Datasource.

Return Value

The procedure returns 1 if the database table is present in the given data source, or 0 otherwise. If the result is 0, the pre-defined identifier CurrentErrorMessage will contain a proper error message.

Note

The Tablename argument of the procedure TestDatabaseTable is case sensitive if the ODBC driver is case sensitive.

See also

The procedures TestDataSource and TestDatabaseColumn.