DBLibUseSQLTable (Property)

Applies To:

Connection object, MetaDataConnection object

Description:

DB-Lib Only. The DBLibUseSQLTable (Property) enables the connection to use Structured Query Language (SQL) to get tables.

Note:

Do not use DBLibUseSQLTable inInteractive Reporting documents to be deployed in the EPM Workspace.

Action:

Read-write, Boolean

Example:

This example shows how to create a connection (OCE) that uses SQL to get tables:

var myCon
myCon = Application.CreateConnection()
myCon.Api = bqApiOpenClient
myCon.Database = bqDatabaseSQLServer
MyCon.HostName ="PlutoSQLSVR"
MyCon.DBLibUseSQLTable = true
myCon.SaveAs("d:\\OCEs\\PlutoSQL.oce")

//Now use this connection in a data model
ActiveDocument.Sections["Query"].DataModel.Connection.Open
("d:\\OCEs\\PlutoSQL.oce")