CreateOLETableScope (Activity)

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
• Example

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 DB Scope. Which table is 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":
x700px

Excel document

See also

• Workflow Designer
• CreateOLESQLScope (Activity)
• CreateOLEOracleScope (Activity)