SendSQL (Method)

Applies To:

Application

Description:

Sends SQL strings to a data source. Data is not retrieved from the database.

This method does not send a SQL statement to the database session to which your query is connected.

Note:

If your SendSQL string sends data modification commands, the database may require a commit statement. The commit behavior of the database may restrict which type of SQL string you can send. Because the SendSQL method requires an Interactive Reporting database connection file (OCE) as an argument, it does not apply to a script written for web client.

Syntax:

Expression.SendSQL(Ocename As String, Username As String, Password As String, SQLString As String)

Expression Required:

An expression that returns an Application object.

Example:

This example shows how to send a SQL Statement to a database associated with an .Interactive Reporting database connection file (OCE):

var SQL = "insert into test (store_id, store) values (2, 'Computer City')"
var OCE = "c:\\OCEs\\Oracle.oce"
var user = "hyperion"
var pass = "hyperion"
Application.SendSQL(OCE,user,pass,SQL)