TimeLimit (Property)

Applies To:

Connection object, MetaDataConnection object, DataModel object, QuerySection object

Description:

Returns or sets the maximum time limit a query can process before timing out. It can be set on the OCE, DataModel or Connection level. The time increment is minutes.

Action:

Read-write, Numeric

Example:

This example shows how to set the TimeLimit (Property) for all the supported objects:

//Connections
var myCon = Application.CreateConnection()
myCon.Api = bqApiSQLNet
myCon.Database = bqDatabaseOracle71
myCon.HostName ="PlutoORACLE"
myCon.TimeLimit = 20 
myCon.SaveAs("d:\\OCEs\\PlutoORACLE.oce")

//DataModel
ActiveDocument.Sections["Query].DataModel.TimeLimit = 30

//Query
ActiveDocument.Sections["Query].TimeLimit = 30