Read Only specifies whether PocketBuilder should update the extended attribute system tables and any other tables in your database. The extended attribute system tables (also known as the extended catalog) consist of five tables that contain default extended attribute information for your database.
The Read Only setting determines whether you can modify (update) the tables in your database. By default, the Read Only check box is cleared in the Database Preferences dialog box. This means that PocketBuilder updates the extended attribute system tables and other tables in your database when you make changes.
No extended attributes in UltraLite
UltraLite does not contain system tables or extended attributes.
If you select the Read Only check box, PocketBuilder does not update the extended attribute system tables or any other tables in your database. You cannot modify (update) information in the extended attribute system tables or any other database tables from the DataWindow painter when the Read Only check box is selected.
You cannot set the Read Only database preference in a PocketBuilder application script.
In the PocketBuilder Database painter, select or clear the Read Only check box in the Database Preferences dialog box as follows:
Select the check box PocketBuilder does not update the extended attribute system tables or any other tables in your database. You cannot modify (update) information in the extended attribute system tables or any other database tables from the DataWindow painter when the Read Only check box is selected.
Clear the check box (Default) PocketBuilder updates the extended attribute system tables and any other tables in your database when you modify them.
The Read Only check box in the Database Preferences dialog box is cleared by default.
If you select the Read Only check box in the Database Preferences dialog box, you cannot modify information in any tables from the DataWindow painter.
Therefore, you can use only:
SELECT and Retrieve statements in the DataWindow and Report painters
SELECT statements in embedded SQL
