Adding and Updating Fields

Prescient Author lets you add fields to the table.

Specify a Field Name for a Field. This name will be the actual name of the column in the database. The field name could be alphanumeric. It should not have any space in between. The field name cannot be started with a number.

Following are steps to add field in the 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 the name of the field in the Field Name text box.
4. Select the data type for the field from Data Type text box. Prescient Author provide int, float, decimal, char, varchar, dateTime, text,money, image, nchar, nvarchar, ntext,and bigint  data types .
5. You can specify size of Char and Varchar in the Size text box.Other data types have their default data size therefore size field will be disabled.
6. You may specify some default value to your field in Default Value text box.
7. Select Allow Null if this field is allowed to be null in database.
8. Specify precision in the Precision text box for decimal data type.
9. You may create foregin constraint on a field having int data type. Check out the Foriegn key checkbox and select the Foregin Field Table by selecting appropriate module.
10. Click on Add Field button. The added field will be listed in listbox below.
11. To update the field you have to double click on the field name, update the field and click on Update button.

Example of Adding Field

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