VisiconX's SQL Wizard helps you create simple-to-complex SQL Select statements quickly. By using the Wizard, you do not need to know SQL Select statement syntax; the Wizard builds the statement for you.
Besides making your job quicker and easier, the SQL Wizard also lets you use query properties. By animating the query properties, you can modify the data displayed based on the value currently assigned to the query property. Animating Query Properties, in the Using VisiconX in iFIX chapter, describes query animation in more detail.
NOTE: CIMPLICITY users need to use CimEdit Basic script to use query properties. For more information, see Using Query Properties in CIMPLICITY.
With the SQL Wizard, you can:
- Select one or more tables to query.
- Select the table columns to display.
- Return rows with unique values, rather than rows with duplicate entries.
- Filter the rows returned based on selection criteria you assign.
- Sort data in ascending or descending order by the values of columns you select.
See Also
