Re: [pilot-db-list] Questions about non-working install for Mac users

[Jan E. <li...@mo...>]

2003-03-11 11:40: Scott Wallace <swa...@my...> is
believed to have typed:

>   This is very interesting.  Would it be possible to examine the=20
> AppInfo block when it is on the palm?  I suppose there are tools to do=20
> this...

I don't know. I didn't find a good one but I didn't look that hard (but
I would like to have one 8-)

> Well, the db3 format doesn't use the standard appinfo structure.
> According to the docs I've read, the appinfo block can contain
> whatever user data one might want, but I could imagine that this
> isn't actually the case. =20

There are several application that doesn't use the standard appinfo so
the problem must be somewhere else

> Have you tried creating a db on the palm, backing up to your mac and=20
> reinstalling the db?  This shouldn't work.   I could try to make=20
> a modification to the file format to make it consistent with normal=20
> expectations about the appinfo block and we could see if that resolves=20
> these mac problems. =20
>=20
> What do you think about trying this experiment? =20

I tried this with the version you sent me and it doesn't work.

What exactly happens during installation of a database, does the program
interacts with the downloaded file in some way during download? (if so,
could there be some little/big endian problem)=20

Some obeservations

Item 1: Corruption occurs going from Mac =3D> Palm

Item 2: Corruption doesn't occur when going Mac =3D> SD Card =3D> Palm

Item 3: I created a database on the Palm, hotsynced, opened my backup
        folder and tried to install it on my Palm but it failed when
        I tried to open it.
       =20
        Then I tried to install it on my SD card and copy it to my
        Palm, which worked! So I assume this means that going from
        Palm to Mac is OK.
       =20
        And here a few interesting things happens. Notation: Org is
        the file that was created on the Mac, Palm the one which
        was installed on the Palm and then synced back, SD the one
        that was installed on the SD, copied to the Palm and synced
        back. The example database defines two strings and has one
        record.

Org looks like this

73 6E 75 74 74 00 00 00 01 75 E4 60 00 00 00 00
00 00 00 00 0E 67 00 00 00 00 00 00 00 00 00 00
00 08 00 00 3E 6F 0A 3F 3E 6F 0A 57 3E 6F 0A 57
00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30
44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00
00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A
48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00
00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00
00 04 00 08 45 74 74 00 54 72 65 00=20

Palm like this
73 6E 75 74 74 00 00 00 01 75 E4 60 00 00 00 00
00 00 00 00 0E 67 00 00 00 00 00 00 00 00 00 00
00 08 00 00 3E 6F 0A 3F 3E 6F 0A 57 3E 6F 0A 57
00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30
44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00
00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A
48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00
00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00
00 04 00 08 45 74 74 00 54 72 65 00=20

And SD like this
73 6E 75 74 74 00 00 00 01 82 2B E0 63 6E 74 6C
00 00 00 04 00 00 00 00 40 C7 8B 0D D8 E8 64 02
00 08 00 00 C2 49 59 BF 3E 6F 0C 92 3E 6F 0C 92
00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30
44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00
00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A
48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00
00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00
00 04 00 08 45 74 74 00 54 72 65 00=20


        Note that the Org and Palm files looks exactly the same, while
        the one who got installed on the SD card is different (the
        name is changed after the 0 but that shouldn't matter). All
        three dates fields are changed but the rest is the same.
       =20
        But in this case it's only thing that has changed, nothing
        extra is inserted there but it still refuses to do anything.

This would suggest that if the only thing that matters is how the file
looks like, then one problem seems to be related to either the dates or
the name of the file. But this doesn't explain the extra info in the
appinfo block described below.

Does Pilot-DB check the creation date against the other two in some way?






       =20

Here is a description I sent to another list

> I compared the faulty database in my backup folder with the
> orginal I tried to install and from what I can understand the
> appinfo block seem to have become corrupted (note I'm looking at
> this file on my Mac so the database have travelled Mac =3D> Palm =3D>
> Mac, the one who travelled Mac =3D> SD Card =3D> Palm =3D> Mac doesn't
> have this problem).
>=20
> There seems be an extra chunk of information (I think 15F bytes)
> at the end of the AppInfo block of the munged file.

Do you get any ideas??

                jem
--=20
Jan Erik Mostr=F6m   je...@mo...    www.mostrom.pp.se