The following examples use a page size of 1024 bytes:
- A fixed length record index file with a record length of 1018 bytes creates a fixed length record Btrieve file with a fixed record length of 1018 bytes.
All the keys must be in the first 1018 bytes of the record.
- A fixed length record index file with a record length of 1019 bytes creates a variable length record Btrieve file with a fixed record length of 1014 bytes.
All the keys must be in the first 1014 bytes of the record.
- A fixed length record index file with a record length of 1010 bytes and one key which allows duplicates creates a fixed length record Btrieve file with a fixed record length of 1010 bytes.
All of the keys must be in the first 1010 bytes of the record.
- A fixed length record index file with a record length of 1011 bytes and one key which allows duplicates creates a variable length record Btrieve file with a fixed record length of 1006 bytes.
All of the keys must be in the first 1006 bytes of the record.
- A fixed length record relative file with a record length of 1014 bytes creates a fixed length record Btrieve file with a fixed record length of 1018 bytes.
The additional four bytes is due to the auto-increment key that is added automatically to the front of each record.
If you are using the opcode 06 action-code for the Callable File Handler call interface, the record length returned is 1014 bytes.
- A fixed length relative file with a record length of 1015 bytes creates a variable length Btrieve file with a fixed record length of 1014 bytes. This is because you are limited to a maximum of 1014 bytes.
This length includes the additional four bytes automatically added to the front of each record, due to the auto-increment key.
If you are using the opcode 06 action-code for the Callable File Handler call interface, the record length returned is 1010 bytes.
- A variable length record index file with a minimum record length of 1014 bytes creates a variable length record Btrieve file with a fixed record length of 1014 bytes.
All of the keys must be in the first 1014 bytes of the record.
- A variable length record index file with a minimum record length of 1015 bytes creates a variable length record Btrieve file with a fixed record length of 1014 bytes.
All of the keys must be in the first 1014 bytes of the record.
- A variable length record index file with a minimum record length of 1006 bytes and one key which allows duplicates creates a variable length record Btrieve file with a fixed record length of 1006 bytes.
All of the keys must be in the first 1006 bytes of the record.
- A variable length record index file with a minimum record length of 1007 bytes and one key which allows duplicates creates a variable length record Btrieve file with a fixed record length of 1006 bytes.
All of the keys must be in the first 1006 bytes of the record.
- A variable length record relative file with a minimum record length of 1010 bytes creates a variable length record Btrieve file with a fixed record length of 1014 bytes.
The additional four bytes is due to the auto-increment key that is added automatically to the front of each record.
If you are using the opcode 06 action-code for the Callable File Handler call interface, the record length returned is 1010 bytes.
- A variable length record relative file with a minimum record length of 1011 bytes creates a variable length record Btrieve file with a fixed record length of 1014 bytes.
The additional four bytes is due to the auto-increment key that is added automatically to the front of each record.
If you are using the opcode 06 action-code for the Callable File Handler call interface, the record length returned is 1010 bytes.