Use Extended Attributes

Description

Controls access to the extended attribute system tables by specifying whether you want PowerBuilder to create these tables. The extended attribute system tables (also known as the extended catalog) consist of five tables that contain default extended attribute information for your database.

By default, the Use Extended Attributes check box is selected in the Database Preferences dialog box. This setting creates the extended attribute system tables the first time you connect to a database using PowerBuilder.

Applies to

All database interfaces

In an application

You cannot set the Use Extended Attributes database preference in code.

In the development environment

In the Database painter, select or clear the Use Extended Attributes check box in the Database Preferences dialog box as follows:

  • Select the check box

    (Default) Creates the extended attribute system tables when connecting to the database for the first time.

  • Clear the check box

    Does not create the extended attribute system tables if they do not exist. Instead, the DataWindow painter use the appropriate default values for extended attributes (such as headers, labels, and text color). If the extended attribute system tables already exist, PowerBuilder does not use them when you create a new DataWindow object.

Default value

The Use Extended Attributes check box in the Database Preferences dialog box is selected by default.

Usage

If you clear the Use Extended Attributes check box in the Database Preferences dialog box, PowerBuilder does not do any of the following:

  • Create the extended attribute system tables

  • Insert, update, or delete rows in the extended attribute system tables

  • Select information (such as header names) from the extended attribute system tables

  • Execute statements that reference the extended attribute system tables

See also

Read Only