Creating and Updating Master Tables

 

Master tables are those tables where you would like to keep information of a certain entity. See example of Master tables.

Prescient Author adds two default fields to table which can be updated or deleted.

First field is primary key for the table. The field name is generated as TableName_id. This is an integer field which stores unique number for a given row.

Another field is added to handle the soft delete of a given row. The field name is generated as Is_Deleted. The default value assigned to this field is false.

Following are the steps to create a Master Table. 

  1. Right click on Master Table option in Module Section of Project Tree. Select Create Table option. OR click on the  Master Tables button on the Prescient Author Navigator dialog box.
  2. Master Table Definition dialog box appears on the screen.
  3. Specify table name in Table Name text box. The table name could be alphanumeric. It should not have any space in between. The table name cannot be started with a number.
  4. You can add the fields in the table. (Refer to Adding and Updating Fields).
  5. You can change the primary key field for table.
  6. You can change or remove the soft delete field.
  7. You may define any field from the table as Front Field of the table. This helps Prescient Author to intellegently show this field in the UI. You may select that field of the table as front field which best represents that table. Generally, name and description fields are best suited as front fields. For example, in case of a table Customer, you may wish to see CustomerName as front field.
  8. The dialog box shows Generate Forms and Reports check box. The check box is default ON. If you do not wish to generate the corresponding UI for your table, you can turn this check box off. If this check box is on, Prescient Author generates master form and report for this table. It also generates menus to access these forms and reports. You may modify these forms and reports later. (Refer to Update Master Form)
  9. Click on Ok Button to create the table.
  10. Prescient Author provide client side validations. On Master Forms Prescient Author uses Dot Net Validation controls like RequireFieldValidator, CustomValidator, Compare Validator for validation.

 

Related Topics

Delete Table

Add Field

Delete Field

Create Reports

 

Example of Master tables

Following example shows a table named 'Customer'. Fields of the table are Customer_Code, Customer_Name, Customer_Address, Customer_Phone_No, Customer_Email_ID.