Changes

Activity:CreateOLEQueryScope (Activity)

8 bytes added, 12:33, 23 February 2015

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 [[Activity:CreateOLEDBScope (Activity)|CreateOLEDBScope]] Activity.

=Description=

{{ActivityInfoBox

| title = Create OLE Query Scope

}}

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 [[Activity:CreateOLEDBScope (Activity)|CreateOLEDBScope]] Activity. ===Arguments===

{| class="wikitable sortable" | width = "50%"

|}

===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.

In the case of a more complex statement where you include more than one table (example: SELECT * FROM TABELE1, TABELE2 where TABELE1.PK = TABELE2.pk ....) then you have to define a unique tablename defining the access indicator for the OLE system.

==Example==

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

[[File:UI_Activity_CreateOLEQueryScope.PNG|x700px]]

==See also==

[[Category:OLE]]

~~[[Category:Activities]]~~

KNO

10,686

edits