AutoCommit (Property)

Applies To:

Connection object, MetaDataConnection object

Description:

Returns or sets the value of a connection object AutoCommit property. Make this property false if your database does not support Auto commit. Use Auto Commit to send commit statements to the database server with each Interactive Reporting SQL statement to unlock used tables for which users are waiting.

Action:

Read-write, Boolean

Example:

This example shows how to create connections and save them locally to file:

var myCon
myCon = Application.CreateConnection()
myCon.Api =bqApiSQLNet
myCon.Database = bqDatabaseSQLServer
myCon.HostName ="PlutoSQLSVR"
myCon.AutoCommit = false
myCon.SaveAs("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\PlutoSQL.oce")
//Now use this connection in a datamodel
ActiveDocument.Sections["SalesQuery"].DataModel.Connection.Open("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\PlutoSQL.oce")