PostSqlForms

Table of contents

Introduction

Copyright

1. User interface

1.1. Main window

1.1.1. Adding a PostgreSQL database

1.1.2. Adding an SQLite database

1.2. The Help file

1.3. Context menu

1.4. Printing

1.5. Keyboard operation

1.6. Displaying the license

1.7. About psf

2. Working with data bases

2.1. The database window

2.2. Checking the pfm_* tables

2.3. Close data base

2.4. Install pfm_* tables

2.5. Install example database

3. Running SQL

3.1. SQL terminal

3.2. Import SQL-script

4. Configuring PostSqlForms

5. Working with forms

5.1. Opening a form

5.2. The form window

5.3. Update record

5.4. Add record

5.5. Delete record

5.6. Status field

5.7. Links to other tables

5.8. Filling out a form

5.9. Views

5.10. Search record in internal buffer

5.11. Forms with a LIMIT-clause in their definition

5.12. Help for form

6. The pfm_* tables

6.1. pfm_form

6.2. pfm_attribute

6.3. pfm_value_list

6.4. pfm_value

6.5. pfm_link

6.6. pfm_report

6.7. pfm_section

6.8. The structure of the pfm_* tables

7. Designing a form

7.1. Modifying or adding a form

7.2. Defining a form's attributes

7.3. Defining links between forms

7.4. Defining value lists

8. Reports

8.1. Running a report

8.2. Designing the data for the report

8.3. Designing the report layout

9. Character encoding

10. Some general hints about SQL

11. The example databases

11.1. The addressbook database

11.2. The customer database