- SQLContext {}, StoredProcedure {}, Styles {}, & Tabs {}

SQLContext {}

WOW can handle most complex SQL queries including ones where the table is dynamically selected. However, the WOW parser is not always able to determine the tables to use for field FD's. In these cases, the SQLContext property can be used to specify the appropriate tables from which to retrieve FD's.

NOTE: This replaces the 'tables' property in the StoredProcedure property group since SQLContext can be used for stored procedures too.

When prompting in such complex SQL queries, even though the tables have been specified using the SQLContext property group, WOW may still not know what FD's to use for each prompt. In these cases, use the FD parameter notation (e.g. ?1234 where the "1234" is the ID of the FD to be used or that prompt). For more details, review Field Descriptor Prompting.

In some cases such as SQL subqueries, WOW may not automatically refresh data in a list if it doesn't know the tables that effect the resulting data. In this case, you can supply “extra” tables on an operations property group forcing WOW to check the last changed date of each table and causing an automatic refresh. For example:

SQLContext{tables:taxonomy.products,TAXONOMYDEV.PRODUCTPRODUCTLINE; }

Refer to WOW Caching Behavior for more information.

Tags: Complex SQL, Invalid table name SQLContext property group

TODO: Add more properties., link to associated topics.

StoredProcedure {}

This property group allows you to set the properties for a stored procedure call.

Styles {}

This property group allows you to specify which CSS styles to use when generating an operation. Of course, any styles referred to in this property group must be defined in a .css files which is used by your application's theme.

Tabs {}

General information on tab layout can be found HERE:

Tab operation association video can be found HERE:

Description of Tab Property Group can be found HERE:

This property group allows you to configure tabs (display the results of an operation in a tabbed layout).

Example: tabParentMode:

Tabs{

hideWhenEmpty:false;

defaultTab:D_CHIPSETS; tabParentMode:edit;

}