Dexterity Limits

The following is a list of limits for the Dexterity development system.

[spacer]

Resource

Category

Limit

Arrays

Size

Up to 32,767 elements in an array.

Constants

Name

Cannot exceed 79 characters.

Dynamic Link Libraries (DLLs)

Parameters

You can pass a maximum of 255 parameters to a DLL.

Fields and data types

Composites

The maximum displayable length is 128 characters, including separator characters.

Standard composites can have up to 9 components.

Extended composites can have up to 128 components.

Button drop list

Drop down list

List box

Non-native list box

Visual switch

Can display a maximum of 32,767 items, each up to 79 characters long.

ListView

Maximum of 256 columns.

Can have up to 15 state images.

Can use up to 4 different overlay images at one time.

Multi-select list box

Can display a maximum of 32 items.

Can display a maximum of 79 characters per line.

Picture

Can store images having sizes up to 32,767 bytes.

Push button

One default button per window.

One cancel button per window.

String

Maximum keyable length is 255 characters.

Text

Can store a maximum of 32,000 characters.

TreeView

Can have up to 15 state images.

Can use up to 4 different overlay images at one time.

Forms

Total number

Maximum of 8191 forms per dictionary for Windows Help to be supported properly.

Global fields

Total number

Maximum of 8191 global fields per dictionary for Windows Help to be supported properly.

Global variables

Total size

There can be up to 64K of global variables.

Local fields

Total number per form

Maximum of 8191 local fields per form for Windows Help to be supported properly.

Menus

Displaying

Application can display a maximum of 15 menus at a time.

Messages

Length

The maximum length of the message, including all arguments in the message, is 255 characters.

Native pictures

Size

Native pictures can be up to 32,767 bytes.

Pictures

Size

Pictures in the picture library can be up to 32,767 bytes.

Procedures

Parameters

Can include a maximum of 255 parameters.

Up to 32K of parameters can be passed to and from a procedure.

Reports

Additional footers

Can have up to 15 additional footers.

Additional headers

Can have up to 15 additional headers.

Legends

Up to 255 legends can be added to a layout.

Text fields

Can display up to 10K of text on a report.

Scripts

run script statement

Can have a maximum of six levels of scripts started with the run script statement.

Local variables

Scripts can have up to 64K of local variable space.

Script size

Scripts can be up to approximately 24,000 characters long, including spaces and comments.

Static strings

Length

Can be up to 79 characters in length.

Tables

Keys

16 keys per table (Dexterity limit).

255 bytes per key (Dexterity limit).

Open tables

The maximum number of open tables is approximately 95.

Ranges

Only one range per table buffer.

Record size (Fixed-length portion)

Maximum of 4,088 bytes (approximately 4K) for Pervasive.SQL

Maximum of 32,767 bytes (32K) for c-tree.

Maximum of 8,060 bytes for SQL.

Record size (Variable-length portion)

32,767 bytes (32K) for Pervasive.SQL and c-tree.

Columns

255 columns per table (SQL limit).

Segments

16 segments per key (Dexterity limit).

119 segments per table for Pervasive.SQL.

384 segments per table for c-tree.

1024 segments per table for SQL.

Sorting

Dexterity can sort tables of up to 1,000,000 records.

Table access

One table buffer per table per form.

User-defined functions

Parameters

A maximum of 254 parameters, plus the return value.

Up to 32K of parameters can be passed to and from a user-defined function.

Virtual tables

Number of tables

Up to 16 standard tables as part of the virtual table.

Keys

16 keys for the virtual table.

Relationships

Only one main branch can have 1-to-many relationships.

Windows

Auto-linking

A window can be auto-linked to one table.

Objects per window

A window can contain up to 32,767 objects.

Selecting objects

You can select up to 200 objects in a window layout at one time.

Tool bar windows

Only one tool bar window can be open in an application at one time.

Total number

Maximum of 15 windows per form for Windows Help to be supported properly.


 


Documentation Feedback