ExternalQuery Members

These members describe an external query for a Profile.

Functions

Name Description
ChangeSQL Return value: Boolean.
ChangeSQLEx Return value: Boolean.
ChangeSQLEx2 Return value: Boolean.
CreateSourceStandardProfileInfo Creates the standard profile information. Return value: SourceStandardProfileInfo.
RemoveSourceStandardProfileInfo Removes the standard profile information.
SyncWithSourceStandardProfile Return value: Boolean.

Properties

Name Description
Columns Returns the collection of External Column objects for this query. Return value: ExternalColumns. This property is read only.
ID Returns the query ID. Return value: Integer. This property is read only.
Name Returns/sets the name of this external query. Return/assignment value: String.
NoDataWhereClause Returns/sets the special SQL WHERE clause that will cause the query SQL to return no data; needed to query the column properties without retrieving data. Return/assignment value: String.
Parameterization Returns/sets if this external query can be parameterized. Return/assignment value: Boolean.
Parameters Returns the parameters. Return value: Parameters. This property is read only.
Parent Returns the parent profile. Return value: ExternalProfile. This property is read only.
QueryData Returns/sets the query data. Return/assignment value: Byte().
SQL Returns/sets the SQL statement for external query. Return/assignment value: String.
SetInfo Returns/sets the set information for external query. Return value: SetInfo. This property is read only.
SourceStandardProfileInfo Returns the standard profile information. Return value: SourceStandardProfileInfo. This property is read only.
TimestampWorkaround Return/assignment value: Boolean.
TreatCommandTextAsStoredProcedure Returns/sets if this external query is a stored procedure. Return/assignment value: Boolean.