List the Contents of a Database

Lists the contents of a database in a text-based list. In order to list a database, you must know the names of the search screen, selection and list format files of the database.

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 defines what kind of listing is made, and which fields of the database content are listed.

When you select the function, the program opens the ../shared/dbases folder by default. The database can also be in the following folders:

active project ../shared/projects/[projid]
../custom/dbases
user's working folder ../user

List the contents of a database:

Select System | Databases | Maintenance > List .
Select the database, and click Open.
The program will ask for the name of the search screen.
Select the search screen, and click Open.
- By default, search screens are located in the ../system/forms folder.
- The customer-edited search screens are located in the ../custom/forms folder.
The program asks for the name of the selection format.
Select the selection format, and click Open.
- By default, selection formats are are located in the ../system/forms folder.
- The customer-edited selection formats are located in the ../custom/forms folder.
The program asks for the name of the list format.
Select the list format, and click Open.
The program opens the search screen you selected.
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.
Select the rows you want to list from the selection format and click OK. Select the rows one by one with the Ctrl key pressed, or select a set of rows as follows:
1. Click the first row.
2. Press the Shift key, and click the last row of the set.
Select an application to open the text file with.
Name and save the text file, if necessary.