Previous Topic

Next Topic

Book Contents

Book Index

Executing a Query

Click Execute in the Misc tab to test the select query created as shown in the Nodes Configuration_Figure 31. A window is displayed showing the columns of the table and the values therein. The number of rows to be extracted can also be specified.

Nodes Configuration_Figure 31: Execute Query

Click Execute, Query Execution Results dialog box is displayed as shown in the figure below:

Nodes Configuration_Figure 32:

Click Final Query, Query will be displayed as shown in the figure below: From here, you can edit and test the query.

final query

When the values of the parent select or cursor table needs to be used by the child select or cursor table, click on the ConditionValues column. The list of values of parent select or cursor table appears. Prior to this, in the query condition of the child select/cursor, select right column name from Virtual Columns condition list. The selected virtual column appears as Condition Key in Test Query pane as shown below. The condition values list appears only if the query of parent select or cursor is executed.

Nodes Configuration_ Figure 33:

Add Description button is added to SelectGroup Description. An Editor will be displayed when clicked on Add Description button, where user can add/modify the description for R2O.

WYSIWYG-101

See Also

Configuring R2O

Adding Select or Cursor

Creating a Query

Adding Conditions

Virtual Columns

Renaming a Select /Cursor

Mapping the Destination

Container Classes

Naming Select or Cursor

Reusing Select or Cursor

Find Option

Delete Node Option

Exception Tab

R2O Menu Options