VisiconX data controls can use SQL commands that allow you to add or update column values to selected database tables. You can use the SQL Wizard to create simple Insert or Update statements, or you can manually enter more complex statements using the Record Source tab of the Data Control OLE Properties dialog box. For more information about manually creating SQL statements, refer to Entering or Pasting an SQL Statement.
VisiconX's SQL Wizard helps you create simple SQL Insert or Update statements quickly. By using the Wizard, you do not need to know SQL statement syntax; the Wizard builds the statement for you.
With the SQL Wizard, you can:
- Select one or more tables to write to.
- Select the table columns you want to write to.
- Filter the rows you are updating, based on selection criteria you assign.
