How Do I ... : Work with databases : Use the SQL editors : Use the INSERT Details window
Use the INSERT Details window
Use the UPDATE Details windowUse the UPDATE Details windowNo tip for this topicNo example for this topicUse the DELETE Details windowUse the DELETE Details window
To interactively create SQL syntax for an INSERT statement:
1. Select Create > INSERT from the Query menu of the SQL Statement - Setitngs window. The INSERT Details window is displayed, with the tables and views of the database defined in the connection specification listed in the Table/view list.
2. Type a name for the query in the Query name text entry field. The name must be unique within a particular access set, and it cannot contain double-byte characters.
3. Type a description for the query in the Description text entry field. (The description is optional.)
4. Use the list panes and menus of the INSERT Details window to define the tables, columns, and clauses to be included in the query. For instructions on using this window, refer to the VA Smalltalk on-line help facilities.
5. To save your query, select Apply.
Your query is saved in the access set and you are returned to the SQL Statement - Settings window. The name and description of your query are displayed in the Query name drop-down list and Description text field, respectively.
Last modified date: 10/02/2020