Re: [pilot-db-list] DB Format

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

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

I got no replies, did this get lost in the ether?

/ Norman Walsh <nd...@nw...> was heard to say:
| |> 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...> | Some people tell you you should not
http://nwalsh.com/            | drink claret after strawberries. They
                              | are wrong.--William Maginn
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.7 <http://mailcrypt.sourceforge.net/>

iD8DBQE+mcrVOyltUcwYWjsRAiyfAJ9t8LRD7+EatV5Ln7Rt/2oT3Ze9OwCfSwo+
AcaeGFakclqGoH77QH1ZFy8=
=Q7Eg
-----END PGP SIGNATURE-----