Insert Statement
This option in the code wizard creates the program code to insert a record into a table.
| Step 1 | Set the cursor at the place in your code where you want to insert the new code lines. |
|
| Step 2 | Start the code wizard. This can be done by clicking the right mouse button and choosing "Code Wizard" from the popup menu, or by using the shortcut "Ctrl+W". |
|
| Step 3 | Choose "add insert statement" |
|
| Step 4 | Choose the table query that you want to insert and click "Finish".  In the 'Table query' field a search string can be entered consisting of the starting letters of the table query to find. |
|
| Step 5 | The lines that are created by the Code wizard are the beginning for a table query in which you fill in the parameters that have to be used to fill all the fields of a single record.
tq_customer.city :=
tq_customer.company := tq_customer.country_code := tq_customer.cust_no := tq_customer.cust_type := tq_customer.email := tq_customer.firstname := tq_customer.lastname := tq_customer.maillist := tq_customer.postcode := tq_customer.street := tq_customer.tel_no := tq_customer.insert () |