Your First Application in 20 Minutes › Using Your Generated Application › Preserving Data

Preserving Data

By default, each time you build your application, CA Plex rebuilds all of the objects you select in the Generate and Build window, including the tables in your database. Because rebuilding a database table erases all data in the table, if you leave your local model set up as it is, you will lose all of the data you just entered the next time you build.

You can prevent losing this data by entering a TBL implement SYS No triple for the table. This keeps the table from being rebuilt the next time you build the entity to which it is scoped (in this case, Project). Only set this triple after you have built the table at least once.

To keep the Project entity table from being regenerated:

1. In the Object Browser, select Project.Physical Table, and drag it to the source object box in the Model Editor.
2. From the verb list, select implement SYS.
3. From the target object list, select the value No.
4. Press Enter.
5. Save your model.

Keep in mind that if you make any changes to an entity that affect its table, such as adding fields to it, you must set the implement SYS value back to Yes, and regenerate the table. Any data in it is lost. If you want to preserve data entered after rebuilding, make sure you reset the implement SYS value to No.