Category : Databases and related files
Archive   : BTRV410.ZIP
Filename : BTRIEVE.CRE

 
Output of file : BTRIEVE.CRE contained in archive : BTRV410.ZIP
SOURCE !INCLUDE('BTRIEVE.CRE')
!
! * * * * BTRIEVE FILE CREATION GROUP * * * *
! See Btrieve 4.10 Manual for further explanation
!
bFileSpec GROUP
bRecLength SHORT !LENGTH OF RECORD
bPageSize SHORT !PAGE SIZE (MULTIPLE OF 512)
bNumIndexes SHORT !NUMBER OF INDEXES (KEYS)
LONG !RESERVED AREA! MUST BE 0 !!
bFileFlags SHORT !FLAGS DESCRIBED BELOW
SHORT !RESERVED AREA! MUST BE 0 !!
bAllocation SHORT !# OF PAGES TO PRE-ALLOCATE
bKeySpecs GROUP,DIM(24) !ALLOWS UP TO 24 KEYS/FILE
bKeyPosition SHORT !STARTING OFFSET OF KEY
bKeyLength SHORT !LENGTH OF KEY SEGMENT
bKeyFlags SHORT !FLAGS DESCRIBED BELOW
LONG !RESERVED AREA! MUST BE 0 !!
bExtendedKey BYTE !
BYTE !RESERVED AREA! MUST BE 0 !!
LONG !RESERVED AREA! MUST BE 0 !!
. .
! * * * * SETTINGS FOR bFileFlags * * * *
! See Btrieve 4.10 Manual for further explanation
!
!
! If bit 0 = 1, the file allows variable length records.
!
! If bit 1 = 1, the file performs blank compression on variable length records.
!
! If bit 2 = 1, Btrieve pre-allocates the number of pages in bAllocation.
!
!
!
!
! * * * * SETTINGS FOR bKeyFlags * * * *
! See Btrieve 4.10 Manual for further explanation
!
!
! If bit 0 = 1, the key allows duplicates.
!
! If bit 1 = 1, the key is modifiable.
!
! If bit 8 = 0, then:
! If bit 2 = 0, the key is string.
! If bit 2 = 1, the key is binary.
!
! If bit 3 = 1, the key has a null value.
!
! If bit 4 = 1, the key has another segment.
!
! If bit 5 = 1, the key is sorted by an alternate collating sequence.
!
! If bit 6 = 1, the key is sorted in descending order.
!
! If bit 7 = 1, the key is a supplemental index. (Set to 0 during bCreate.)
!
! If bit 8 = 1, the key is an extended type. (Bit 2 is ignored in this case.)
!
!
! * * * * EXTENDED KEY TYPES IF BIT 8 = 1 * * * *
! See Btrieve 4.10 Manual for further explanation
!
! * * * * VALUES AND MEANINGS FOR bExtendedKey * * * *
!
! 0 = string - Regular ASCII string with known length.
! 1 = integer - INTEL binary integer format. Must contain an even
! number of bytes. High & low order bytes reversed.
! Sign stored in first nibble of low order byte.
! 2 = float - IEEE standard 4 or 8 byte float. (See below.)
!  4 byte float consists of a 23 bit mantissa, an
! 8 bit exponent biased by 127 and a sign bit.
!  8 byte float consists of a 52 bit mantissa, an
! 11 bit exponent biased by 1023 and a sign bit.
! 3 = date - 4 bytes. Byte: 1=day, 2=month, 3 & 4=year.
! 4 = time - 4 bytes. Byte: 1=100ths, 2=secs, 3=mins, 4=hour.
! 5 = decimal - Sign extended packed-decimal like Clarion's.
! 6 = money - Same as decimal.
! 7 = logical - A 1 or 2 byte value, keyed as a string type.
! 8 = numeric - Stored as ASCII strings, right justified with
! leading 0's. Each digit occupies 1 byte. Rightmost
! byte contains an embedded sign as follows:
! Positive: 0 1 2 3 4 5 6 7 8 9
! w/sign : { A B C D E F G H I
! Negative: 0 1 2 3 4 5 6 7 8 9
! w/sign : } J K L M N O P Q R
! 9 = bfloat - Single or Double precision real number compatible
! with Microsoft BASIC. See manual for details.
! 10 = lstring - Pascal string, first byte contains length.
! 11 = zstring - Null terminated string (ASCIIZ) compatible with 'C'.
! 14 = unsigned binary - Same as integer without sign.


  3 Responses to “Category : Databases and related files
Archive   : BTRV410.ZIP
Filename : BTRIEVE.CRE

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/