Modifying a Resident Table (Magic xpa 3.x)
Resident tables are read-only, and cannot be modified while stored in memory. If the physical table (in the database) was modified, you can use the DbReload function to reload the table.
To modify this table, there is a need to create a duplicate entry in the Data repository that is different from the first one only in terms of the Resident property.
When there is a need to modify this table you should create a program that accesses the physical table using the duplicate entry and modify the table.
Note:Since the tables are loaded on each client memory, modifications to the physical table will not be reflected in the loaded tables, until the application is reloaded by each client or the table is manually reloaded during application execution
To reload the resident table during application execution, you can use the DbReload function
Note: It is recommended to set an application event that can be used anywhere in the application that allows such a procedure.