Writing to a Database

Writing to a database means that you can insert or update the column values of the selected database table. 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.

By using the Wizard, you do not need to know SQL Insert or Update statement syntax; the Wizard builds the statement for you.

TIP: SQL statements must follow standard SQL-92 conventions. Consistent with SQL standards, any statements you enter are not case-sensitive.

 

See Also