Jump to: navigation, search

CreateOLEQueryScope (Activity)


Revision as of 15:45, 23 February 2015 by KNO (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

[edit]

Description

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

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".
CreateOLEQueryScope

See also