Páginas filhas
  • Create a new field

How to create a custom field in a table

Product:

Microsiga Protheus

Versions:

11 and 12

Step by step:

Here is how to create a new field in Protheus:
- Access Configurator > Database>  Dictionary > Databases.

- Click Data Dictionary, select the table where the field will be added and click Edit.



- Expand the table, click Fields and click Include.



- In Field, enter the name of the field. It must start with the prefix of the table. For example, in table SA1, the prefix is A1_, then the name of the field has to be A1_CAMPO.



- Fill in the other required fields of the Field tab, such as Type, Size, Context, and Property.

- In the Info tab, the required field is Title, which is the text that will appear on the routine screen.

- In the Use tab, define how the field will be used. If it is Required, check this box. The Used option indicates whether the field will be used in the table and showed on the routine. The Browse option indicates whether the field will be displayed in the browse of the routine, where the records are listed.

- With the basic configuration made, click Save.

- On the field listing screen, click Confirm. (seleção)




- In the table listing screen, click Update Database.




Warning:

This ‘Update Database’ procedure is intended to confirm the inclusion of the field in the table in the database. This procedure must be done exclusively, that is, there can be no user with an open routine using the table involved.


- On the Data Dictionary Update screen, click Next.



- On the next screen, click Next again.

- Wait for processing. At the end, a screen indicating Update completed successfully will be displayed.

- Click Finish.




Notes: