ReportingServicesRunUserDefinedSQL Method

Executes and retrieves the tabular results for the user defined sql.

Namespace: FactoryLogix.xTend.Analytics
Assembly: FactoryLogix.xTend.API (in FactoryLogix.xTend.API.dll) Version: 8.245.0.0 (8.245.0.0)

Syntax

C++

Copy

public DataTable RunUserDefinedSQL(
	Guid sessionId,
	string sql
)

Public Function RunUserDefinedSQL ( 
	sessionId As Guid,
	sql As String
) As DataTable

public:
virtual DataTable^ RunUserDefinedSQL(
	Guid sessionId, 
	String^ sql
) sealed

abstract RunUserDefinedSQL : 
        sessionId : Guid * 
        sql : string -> DataTable 
override RunUserDefinedSQL : 
        sessionId : Guid * 
        sql : string -> DataTable

Parameters

sessionId: Type: SystemGuid
The session identifier that was returned by the Connect(String, String, String, String, String) method.
sql: Type: SystemString
The sql query to be executed.

Return Value

Type: DataTable
A DataTable object represeting the results of the query.

Exceptions

Exception	Condition
InvalidSessionException	Thrown if the sessionId parameter is invalid.

Reference

ReportingServices Class

FactoryLogix.xTend.Analytics Namespace

ReportingServicesAddLanguageSpecificTextSet("LSTCB67999B_0?cpp=::|nu=.");RunUserDefinedSQL Method

Parameters

Return Value

Reference

ReportingServicesRunUserDefinedSQL Method