Lesson 8: Application Tutorial  Lesson 8: Application Tutorial

Use the Data button

Note

Now you use the Data button to run your form. You add a new contact and change information about an existing one.

  1. Click the Data button.

    Your form displays. Notice that title bars identify your application and the particular part you are using. You also have the usual form toolbar that lets you view, add, and update information in the database.

    Shown is the Contacts application screen with a completed form titled Maintain Contact Information. At left are labeled text fields with actual data for a contact. Across the top right are buttons labeled Add a contact, Delete a contact, and Save changes. Under them is a scrollable table of contacts. Visible are columns of data labeled ID, Last Name, First Name, and Job Role.

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

    A blank form displays.

  3. Enter information for a new contact.

    Use 62 for the Id entry and make up the rest.

    Be sure to fill in all blanks. (The only columns you can skip are phone and fax; the other columns are defined as required in the database.) Use the Tab key to move from box to box.

    Shown is a completed Maintain Contact Information for a new contact with the I D of 62.

  4. Click the Save changes button in the form.

    Your new contact goes into the database. You will see it shortly.

    Next you want to display information on the contact with Id 37 so that you can make a correction.

    NoteAbout updating the database and canceling changes You can click the Update button to update the database immediately; or you can wait until you close the form, and InfoMaker prompts you then to see if you want to update the database.

    The Cancel Changes menu item on the Rows menu cancels any changes you have made since the last time you clicked Update.

  5. Click the Criteria button to display a blank form for setting retrieval criteria.

    Type 37 in the Id box.

    Criteria button

    This sets the retrieval criteria.

  6. Click the Apply button.

    Apply button

    This applies the retrieval criteria. InfoMaker retrieves the row with the Id 37.

    Shown is a Maintain Contact Information form showing all the data for I D 37 as stored in the contacts grid.

  7. Change the Street to 134 Cherry St.

    Click the Save changes button in the form.

    Your changes are added immediately to the database.

  8. Click the Next button.

    Next button

    A message box displays because you have set criteria that allow only row 37 to be retrieved. You need to remove the criteria or specify other criteria.

    Shown is a message box titled Maintain Contact Information with an exclamation point icon and the message, " This is the last row for this table ! "

  9. Click OK to close the message box.

    Click the Criteria button.

    Criteria button

  10. Select 37 and press the delete key to delete 37 from the Id box.

    Click the Apply button.

    Apply button

    Now you have no criteria, so InfoMaker retrieves all rows.

  11. Select File>Close from the menu bar.

    Your form closes.




Copyright © 2011. Sybase Inc. All rights reserved. Lesson 8: Application Tutorial

View this document as PDF