Jam.py documentation

Item Editor Dialog

Item Editor dialog opens when a developer selects a Group node in the project tree of the Application builder and click on the New or Edit button to create a new item or modify a selected one. See Items.

Item Editor Dialog

The upper part of the Item Editor dialog have the following fields:

  • Caption - the item name that appears to users.

  • Name - the name of the item that will be used in programming code to get access to the item object. It should be unique in the project and should be a valid python identifier.

  • Table - the name of the table that will be created in the project database. This name is specified when creating an item, and can not be changed later.

  • Primary key field - by clicking on the button to the right of this attribute you can specify the primary key field for the item. If the primary key field was defined for the group that owns the item it will be displayed there by default, otherwise you have to create this field first.

  • Deleted flag field - by clicking on the button to the right of this attribute you can specify the field that will serve as a deleted flag for the item. If the deleted flag field was defined for the group that owns the item it will be displayed there by default, otherwise you have to create this field first.

  • Visible - use this checkbox to set item’s visible attribute. The value of this attribute can be used in code on the client to create menu items and so on.

  • Soft delete - when this check-box is checked, the delete method does not erase a record physically from the table, but uses this field to mark the record as deleted. See Common fields, delete method (server), delete method (client).

  • Virtual table - if this checkbox is checked, no database table will be created. Use this options to create an item with in-memory dataset or to use its modules to write code. This checkbox must be set when creating an item and can not be changed later.

  • History - if this checkbox is checked, the application will saving for this item audit trail/change history made by users, see Saving audit trail/change history made by users

  • Edit lock - if this checkbox is checked, the application will use record locking while users concurrently edit a record, see Record locking

In the center part of the Item Editor dialog there is a table containing a list of fields, defined for the item. To add, modify or delete a field use the following buttons:

  • New - click this button to invoke the Field Editor Dialog to create a new field.

  • Edit - click this button to invoke the Field Editor Dialog to modify a selected field.

  • Delete - click this button to delete a field selected in in the field list.

In the bottom-right corner of the Dialog form there are two buttons:

  • OK - click this button to save change you made. If the Virtual table checkbox is not checked and DB manual update parameter in the project Database Dialog is not set, the application will generate and execute SQL query to update the item table in the project Database (changes made to the fields will be applied to the table).

  • Cancel - click this buttons to cancel the operation.