Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Read Only – PB Docs 2022 – PowerBuilder Library

Read Only – PB Docs 2022

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.

Applies to

All database interfaces

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 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.

  • Clear the check box

    (Default) PowerBuilder updates the extended attribute system
    tables and any other tables in your database when you modify
    them.

Default value

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

See also

Use Extended Attributes


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x