Microframe Corporation 3007 Series Betriebsanweisung PDF herunterladen (Seite 76)

1-68

Status Codes

Nullable Columns

Note that nullable columns must also be considered. For example,

in a data files with 4096 byte page size you are limited to 119 index

segments per file. Because each indexed nullable column with true

null support requires an index consisting of 2 segments, you cannot

have more than 59 indexed nullable columns in a table (or indexed

nullable true null fields in a Btrieve file). This limit is smaller for

smaller page sizes.

Any file created with file version set to 7.x or later, and

TRUENULLCREATE set to the default value of On, has true null

support. Files created using an earlier file format, or with

Pervasive.SQL 7, or with TRUENULLCREATE set to Off, do not have

true null support and do not have this limitation.

27: The key position is invalid

The specified key field position is less than 1 or exceeds the defined

record length for the file. Either the key position is greater than the

record length or the key position plus the key length exceeds the

record length.

28: The record length is invalid

The physical record length, which is the logical record length

specified when creating the file plus any additional overhead for

duplicate keys, reserved duplicate pointers, variable record pointers,

and blank truncation information must be less than or equal to the

page size minus 10 bytes (8 bytes if creating files in version 5 file

format), and must be greater than or equal to 4 bytes.

For key-only files, the maximum record length is 253 bytes (255

bytes if creating files in version 5 file format).

For more information about calculating the physical record length,

see Pervasive PSQL Programmer's Guide.

29: The key length is invalid

The MicroKernel returns this status code for the following situations

pertaining to the Btrieve Create or Create Index API operations. See

Create (14) and Create Index (31), both in Btrieve API Guide, which

is part of the Pervasive PSQL Software Development Kit (SDK).

 The length of the entire key (all segments) exceeds 255.

1 2 ... 71 72 73 74 75 76 77 78 79 80 81 ... 251 252

Keine Kommentare

Microframe Corporation 3007 Series Betriebsanweisung Seite 76