Read Only database preference
Description
Read Only specifies whether PowerBuilder 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 PowerBuilder updates
the extended attribute system tables and other tables in your database
when you make changes.
If you select the Read Only check box, PowerBuilder 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.
Controls
-
All database interfaces
Context
In an application
You cannot set the Read Only database
preference in code.
In the development environment
In the Database painter, select or clear the Read Only check
box in the Database Preferences dialog box as follows:
-
Select
the check boxPowerBuilder 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) PowerBuilder updates the extended attribute system
tables and any other tables in your database when you modify them.
Default
The Read Only check box in the Database Preferences dialog
box is cleared by default.
Usage
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 painter -
SELECT statements in embedded SQL