CreateOLEQueryScope (Activity)
Revision as of 12:57, 26 January 2015 by MHM (Talk | contribs) (Created page with "{{ActivityInfoBox | title = Create OLE Query Scope | name = CreateOLEQuery | image = 220px | imagecaption = CreateOLEQueryScope (Exp...")
| Create OLE Query Scope | |
|---|---|
| Name | CreateOLEQuery |
| Purpose | Access single table via OLE |
| Category | UBIK Data Exchange |
| Returns | True if successful |
| Version | 2.4.1+ |
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.
Contents
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.
Example
The CreateOLEQueryScope activity, as used in the larger example "Read MetaClass names from UBIK database":
