Difference between revisions of "Activity:CreateOLEQueryScope (Activity)"

Create OLE Query Scope
Name	CreateOLEQuery
Purpose	Access database data via OLE
Category	UBIK Data Exchange
Returns	True if successful
Version	2.4.1+

Revision as of 11:36, 23 February 2015

The CreateOLEQueryScope Activity provides access to a tables/views within an OLE compliant database by defining a SQL statement. It is typically nested within a CreateOLEDBScope Activity.

Arguments

Argument	Type	Direction	Purpose
DisplayName	String	In	The display name of the activity
Tablename	String	In	The unique tablename of the statement
SQLStatement	String	In	The database statement
Rows	IEnumerable<DataRow>	Out	A list of all rows of the table
Result	Boolean	Out	True if successful, false if failed

Usage

This activity is used to access a table(s) or view(s) within a valid OLE DB Scope. The data access is defined by a dtabase SQL Statement.

Tablename

If you are accessing a single table with the statement (example: SELECT * FROM TABELE1), then the table name is optional. In the case of a more complex statement where you include more than one table (example: SELECT * FROM TABELE1, TABELE2 where TABELE1.PK = TABELE2.pk ....) then you have to define a unique tablename defining the access indicator for the OLE system.

Example

The CreateOLEQueryScope activity, as used in the larger example "Read MetaClass names from UBIK database":

@@ Line 10: / Line 10: @@
 }}
-The CreateOLEQueryScope Activity provides access to a tables/views within an OLE compliant database by defining a SQL statement. It is typically nested within a [[CreateOLEDBScope (Activity)|CreateOLEDBScope]] Activity.
+The CreateOLEQueryScope Activity provides access to a tables/views within an OLE compliant database by defining a SQL statement. It is typically nested within a [[Activity:CreateOLEDBScope (Activity)|CreateOLEDBScope]] Activity.
 ==Arguments==