Re: [pilot-db-list] DB Format

[Norman W. <nd...@nw...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

|> A lot of developpers ask us the update of the Format.txt file
|> which describes the format of the database of Pilot-DB.
|> I join here the new file, that you will be able to find with
|> the next releases.
|> 
|> Send us your questions or the parts to update.

Ok, I'm looking at the appinfo from my test database and it looks like
this:

appinfo  :
00.00.00.09.00.00.00.32.73.74.72.69.6E.67.00.62
  .  .  .  .  .  .  . 2. s. t. r. i. n. g.  . b
6F.6F.6C.00.69.6E.74.00.66.6C.6F.61.74.00.64.61
 o. o. l.  . i. n. t.  . f. l. o. a. t.  . d. a
74.65.00.74.69.6D.65.00.6C.69.73.74.31.00.6C.69
 t. e.  . t. i. m. e.  . l. i. s. t. 1.  . l. i
6E.6B.00.6C.69.6E.6B.65.64.00.00.01.00.12.00.00
 n. k.  . l. i. n. k. e. d.  .  .  .  .  .  .  
00.01.00.02.00.08.00.03.00.04.00.06.00.07.00.0A
  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  
00.02.00.10.00.06.00.03.0C.00.6F.6E.65.00.74.77
  .  .  .  .  .  .  .  .  .  . o. n. e.  . t. w
6F.00.33.00.00.02.00.24.00.07.4D.6F.76.69.65.73
 o.  . 3.  .  .  .  . $.  .  . M. o. v. i. e. s
00.2E.00.00.00.00.00.00.00.00.00.00.00.00.00.00
  . ..  .  .  .  .  .  .  .  .  .  .  .  .  .  
00.00.00.00.00.00.00.00.00.00.00.03.00.41.00.04
  .  .  .  .  .  .  .  .  .  .  .  .  . A.  .  
00.00.00.00.00.80.00.02.00.00
  .  .  .  .  .  .  .  .  .  

Going through the header, I find:

  flags    : 0
  numChunks: 9

Ok so far.

  chunk 0
          0
          50
          string,bool,int,float,date,time,list1,link,linked

The field names...

  chunk 1
          1
          18
          0,1,2,8,3,4,6,7,10

The field types...

  chunk 2
          2
          16
          6[6], 3, 3072
                  one,two,3

The list of values for field 6...

  chunk 3
          2
          36
          7[7], 76694d6f, 25971


Ok, chunk 3 is of type 2 and it's for field number 7 which is type 7
(coincidentally). Type 7 is a link, so this chunk should contain:

  Link Field Type:
    UInt16 fieldNum
    UInt32 recordID (of the ChooserDB record corresponding to the database.)
    UInt16 filedNum (of the record to display.)

But it's length is 36 which seems really odd. And the actual data in the field

  00.02.00.24.00.07.4D.6F.76.69.65.73
    .  .  . $.  .  . M. o. v. i. e. s
  00.2E.00.00.00.00.00.00.00.00.00.00.00.00.00.00
    . ..  .  .  .  .  .  .  .  .  .  .  .  .  .  

doesn't look like it corresponds. It looks more like the name of the linked
database is in there.

                                        Be seeing you,
                                          norm

- -- 
Norman Walsh <nd...@nw...> | It is not failure of others to
http://nwalsh.com/            | appreciate your abilities that should
                              | trouble you, but rather your failure to
                              | appreciate theirs.--Confucius
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.7 <http://mailcrypt.sourceforge.net/>

iD8DBQE+gbSDOyltUcwYWjsRAmRRAJ9QqDUl7G3koVqayvqmtH0t2dWHQwCfegBy
cYBnaCnqgNSt0JEnBxGQL2g=
=RQnp
-----END PGP SIGNATURE-----