Specifying columns and their values for an SQL UPDATE or INSERT

Using the SQL Assist SmartGuide Insert/Update page, you can specify columns and their values.

sqlains2.gif (10027 bytes)

To specify columns and values for an insert:

  1. From the SQL Assist SmartGuide, click the Insert button and choose the table where you want to insert.
  2. Click Next. The Insert window displays.
  3. Specify values for the columns that you want to insert in the Value list and click Next.  The SQL statement displays.
  4. Click Finish to generate the INSERT SQL statement. 


sqlaupd.gif (10311 bytes)

To specify columns and values for an update:

  1. From the SQL Assist SmartGuide, click the Update button and choose the table you want to update.
  2. Click Next. The Update window displays.
  3. Specify values for the columns that you want to update in the Value list and click Next.  You can specify conditions for the SQL statement.
  4. Click Finish to generate the UPDATE SQL statement. 

You can also specify parameters in the Value list. If a parameter is specified, its value is used in the INSERT or UPDATE statement. A parameter is specified in the format :parm, where parm is the parameter name. For example, :empid is a valid specification for a parameter named empid.

To cancel visual composition of the SQL statement, select Cancel.


Composing an SQL INSERT, UPDATE or DELETE
Specifying the tables for an SQL statement
Specifying columns and their values for an SQL UPDATE or INSERT
Specifying search conditions
Displaying the SQL statement