Creating SQL Statements with the SQL Wizard

To create an SQL statement with the SQL Wizard:

1. Open the VisiconX Data Control OLE Properties dialog box. For information on how to do this in your product, refer to the Accessing VisiconX OLE Control Properties section.
2. Click the Record Source tab.
3. Select SQL Command from the Command Type list box.
4. Click the SQL Wizard button. The Welcome dialog box appears.
5. On the SQL Wizard Welcome page, optionally select the Do not show Welcome Dialog again check box, then click Next. The Select Operation dialog box appears.
6. On the Select Operation dialog box, click the type of SQL statement you want to construct. You can construct an SQL SELECT, SQL INSERT, or SQL UPDATE command.
7. Proceed through the appropriate SQL command construction wizard.
8. At the end of the wizard, click OK in the Finish dialog box to return to the Data Control OLE Properties dialog box.

See Also