Difference between revisions of "Activity:CreateOLETableScope (Activity)"
(→See also) |
(→See also) |
||
| (14 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| + | The CreateOLETableScope Activity provides access to a single table/view within an OLE compliant database. It is typically nested within a [[Activity:CreateOLESQLScope (Activity)|CreateOLESQLScope ]] or a [[Activity:CreateOLEOracleScope (Activity)|CreateOLEOracleScope ]] activity. | ||
| + | |||
| + | =Description= | ||
{{ActivityInfoBox | {{ActivityInfoBox | ||
| title = Create OLE Table Scope | | title = Create OLE Table Scope | ||
| Line 10: | Line 13: | ||
}} | }} | ||
| − | + | ===Arguments=== | |
| − | + | ||
| − | ==Arguments== | + | |
{| class="wikitable sortable" | width = "50%" | {| class="wikitable sortable" | width = "50%" | ||
| Line 27: | Line 28: | ||
|} | |} | ||
| − | ==Usage== | + | ===Usage=== |
| − | This activity is used to access a single table or view within a valid OLE | + | This activity is used to access a single table or view within a valid OLE Oracle or SQL Scope. The '''table accessed''' is hereby determined by the '''name of the Activity''', also accessible via the argument ''DisplayName''. |
| + | |||
| + | =Example= | ||
| + | ===SQL Server data source=== | ||
| + | The CreateOLETableScope activity, as used in the larger example "Read MetaClass names from UBIK database":<br /> | ||
| + | [[File:UI_Activity_CreateOLEDBScope_Example.png|x700px|border|CreateOLETableScope]] | ||
| − | == | + | ===Excel document=== |
| − | + | [[File:UI_Activity_CreateOLETableScope_Excel.png|border|CreateOLETableScope]] | |
| − | + | <headertabs /> | |
==See also== | ==See also== | ||
* [[Workflow Designer]] | * [[Workflow Designer]] | ||
| − | * [[Activity: | + | * [[Activity:CreateOLESQLScope (Activity)]] |
| + | * [[Activity:CreateOLEOracleScope (Activity)]] | ||
| + | * [[Activity:CreateOLEExcelScope (Activity)]] | ||
| + | * [[Activity:CreateOLERow (Activity)]] | ||
| + | * [[Activity:EditOLERow (Activity)]] | ||
| + | * [[Activity:EditOLEValue (Activity)]] | ||
| − | [[Category:OLE | + | [[Category:OLE|CreateOLETableScope (Activity)]] |
| − | + | ||
Latest revision as of 07:57, 11 April 2018
The CreateOLETableScope Activity provides access to a single table/view within an OLE compliant database. It is typically nested within a CreateOLESQLScope or a CreateOLEOracleScope activity.
[edit]
Description
| Create OLE Table Scope | |
|---|---|
| Name | CreateOLETable |
| Purpose | Access single table via OLE |
| Category | UBIK Data Exchange |
| Returns | True if successful |
| Version | 2.4.1+ |
Arguments
| Argument | Type | Direction | Purpose |
|---|---|---|---|
| DisplayName | String | In | The name of the table (and the activity) |
| Rows | IEnumerable<DataRow> | Out | A list of all rows of the table |
| Table | DataTable | Out | The table as DataTable object |
| Result | Boolean | Out | True if successful, false if failed |
Usage
This activity is used to access a single table or view within a valid OLE Oracle or SQL Scope. The table accessed is hereby determined by the name of the Activity, also accessible via the argument DisplayName.
Example
SQL Server data source
The CreateOLETableScope activity, as used in the larger example "Read MetaClass names from UBIK database":
Excel document
