First Guide to SQL Anywhere Studio
   PART 2. Getting Results with SQL Anywhere Studio
     CHAPTER 7. Creating Forms with InfoMaker       

Use the form to update the database

Now you will use the form to add a new contact to the database.

1. Click the Run button in the PainterBar.

   Your finished form displays with data in place. The report on the form gives you a way to see all your contact data.

   

2. Click the Add a contact button in the form.

   An empty form displays. You will use this form to enter a new contact.

   

   The cursor is in the Id box, but you don't know the next available number. You will look in the report to see what number was used last.

3. In the report window, use the scrollbar to scroll down to the last row of the report and check the value in the Id column.

   If the data has not been changed since installation, the value will be 60. So the next available number is 61.

   

4. Click the Id column and type 61.

   

5. Press tab and type Carter for Last Name.

   Press tab and type Jimmy for First Name.

   Press tab.

6. Press tab and type ma for title or, if a drop down box is presented select Marketing for Job Role.

   Job Role or Title?     In the Getting Started with InfoMaker manual there is a tutorial on working with tables. In this tutorial, the title column has a drop down box defined and the column header is changed from title to Job Role. Depending on which tutorials you have completed, you will see either Job Role or Title in you form. To look at the InfoMaker Getting Started tutorials see the following URL:

   Define a DropDownListBox edit style of job roles, change the column header and label to Job Role, and enlarge the display width of the column to 1.5 inches

   

7. Press tab and type Peanut Way for Street.

8. Press tab and type Atlanta for City.

9. Press tab and select GA for State (another dropdown listbox).

10. Press tab.

    To determine what to enter for Zip, scroll the report until you find another Atlanta entry.

    Then click the Zip box in the form and type the zip code you see in the report.

    

11. Press tab and type 4045557833 for Phone.

    Notice that you type only the digits. The form formats the phone number. An Edit Mask edit style was defined for this column to handle the formatting. This edit style is stored in the repository.

12. Press tab and type 4045554291 for Fax.

    This is what your screen should look like now.

    

13. Click the Save changes button in the form to update the database with the new contact.

    The database is updated.

    Note that the report always displays the information from the database when you start running the form. If you update the database, the report does not show the updates. To update the report, you return to the workspace and rerun the form.

14. Click the Design button in the PainterBar to return to the Form painter workspace.

    Click the Run button again and scroll the report to the 61st row in the report.

    Notice that your report has been updated.

15. Click the Design button in the PainterBar to return to the Form painter workspace.

16. Select File->Close from the menu bar.

    If you haven't already saved the current version of the form, you will be prompted to save changes.

17. Click Yes.

    This closes the Form painter. You return to the PowerBar.