List the Contents of a Database

General

  • Use this function to list the contents of a database in a text list.
  • In order to list a database, you must know the names of the appropriate search screen, selection and list format files.
    • The search screen is used to restrict the content that is listed in the database.
    • You can use the selection format to select the database rows you want to list.
    • The list format determines what type of listing and which fields of the database's contents are listed.

List the Contents of a Database

  1. Select System | Databases | Maintenance > List.
    • The program opens a list of the databases (in ../vxg4*/shared/dbases folder).
    • The database can also be in the following folders:
      • Active project ../shared/projects/[projid].
      • ../custom/dbases
      • user's working folder ../user
  2. Select the database you want to list, and click Open.
    • The program will ask for the name of the search screen.
  3. Select the search screen, and click Open.
    • By default, search screens are located in the ../vxg4*/system/forms folder.
    • The customer-edited search screens are located in the ../vxg4*/custom/forms folder.
    • The program asks for the name of the selection format.
  4. Select the selection format, and click Open.
    • By default, the selection formats are located in the ../vxg4*/system/forms folder.
    • The customer-edited selection formats are located in the ../vxg4*/custom/forms folder.
    • The program asks for the name of the list format.
  5. Select the list format, and click Open.
    • The program opens the search screen you selected
  6. Enter the search data that delimits the contents of the database and click OK.
    • If you do not enter search criteria, the entire database content is listed.
  7. Select the rows you want to list from the selection format and click OK.
    • Hold down the Ctrl key if you you want to select several rows.
    • Hold down the Shift key if you want to select consecutive rows from the list.
  8. Select an application to open the text file with
  9. Name and save the text file as needed.