Home Cart [Log In] About Us Contact Us

Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_LinkerTable Linker

Public Function ExternalTableLink (
ExternalTableName As String,
DatabaseTypeStr As String,
DbFilePath As String,
ODBCConnectString As String,
ODBCPassword As String,
ADOConnectString As String,
UseADO As Boolean,
Optional SuppressErrorMsg As Boolean = False
) As String

Link a table from an external database as the 'test table'

ExternalTableName as String

The name of the table in the external database

DatabaseTypeStr as String

The database type (Access/Mssql)

DbFilePath as String

The file path of the external database

ODBCConnectString as String

The ODBC connection string (for an MSSQL database)

ODBCPassword as String

The ODBC password (for an MSSQL database)

ADOConnectString as String

(no description)

UseADO as Boolean

(no description)

Optional SuppressErrorMsg as Boolean = False

Suppress any error message

Call Template:

Dim s As String

s = xf.Linker.ExternalTableLink(ExternalTableName, DatabaseTypeStr, DbFilePath, ODBCConnectString, ODBCPassword, ADOConnectString, UseADO)

s = xf.Linker.ExternalTableLink(ExternalTableName, DatabaseTypeStr, DbFilePath, ODBCConnectString, ODBCPassword, ADOConnectString, UseADO, SuppressErrorMsg)