Changes

Activity:CreateOLEQueryScope (Activity)

1,560 bytes added, 12:57, 26 January 2015

Created page with "{{ActivityInfoBox | title = Create OLE Query Scope | name = CreateOLEQuery | image = [[File:UI_Activity_CreateOLESQLScope.png|220px]] | imagecaption = CreateOLEQueryScope (Exp..."

{{ActivityInfoBox
| title = Create OLE Query Scope
| name = CreateOLEQuery
| image = [[File:UI_Activity_CreateOLESQLScope.png|220px]]
| imagecaption = CreateOLEQueryScope (Expanded)
| 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)|CreateOLEDBScope]] Activity.

==Arguments==

{| class="wikitable sortable" | width = "50%"
|-
! Argument!! Type !! Direction !! Purpose
|- align="left"
| DisplayName|| {{String_MSDN}}|| In || The display name of the activity
|- align="left"
| Tablename|| {{String_MSDN}}|| In || The unique tablename of the statement
|- align="left"
| SQLStatement|| {{String_MSDN}}|| In || The database statement
|- align="left"
| Rows|| IEnumerable<DataRow>|| Out || A list of all rows of the table
|- align="left"
| Result|| {{Boolean_MSDN}}|| 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":

[[File:UI_Activity_CreateOLEQueryScope.png|x700px]]

==See also==
* [[Workflow Designer]]
* [[CreateOLEDBScope (Activity)]]

[[Category:Workflows]] [[Category:Activities]] [[Category:Interfacing]] [[Category:OLE]]

MHM

1,579

edits