Changes

Activity:CreateOLETableScope (Activity)

1,522 bytes added, 12:00, 9 January 2015
Created page with "{{ActivityInfoBox | title = Create OLE Table Scope | name = CreateOLETable | image = [[File:UI_Activity_CreateOLESQLScope.png|220px]] | imagecaption = CreateOLETableScope (Exp..."
{{ActivityInfoBox
| title = Create OLE Table Scope
| name = CreateOLETable
| image = [[File:UI_Activity_CreateOLESQLScope.png|220px]]
| imagecaption = CreateOLETableScope (Expanded)
| purpose = Access single table via OLE
| category = UBIK Data Exchange
| returns = True if successful
| version = 2.4.1+
}}

The CreateOLETableScope Activity provides access to a single table/view within an OLE compliant database. 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 name of the table (and the activity)
|- align="left"
| Rows|| IEnumerable<DataRow>|| Out || A list of all rows of the table
|- align="left"
| Table|| DataTable|| Out || The table as DataTable object
|- align="left"
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
|}

==Usage==
This activity is used to access a single table or view within a valid OLE DB Scope. Which table is accessed is hereby determined by the name of the Activity, also accessible via the argument ''DisplayName''.

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

[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]]

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

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