Re: [Q] SQLITE version

From: Theodore E Poe Jr. <tpoe_at_keyspanenergy.com>
Date: Fri, 10 Jan 2003 08:56:39 -0500

I went to the sqlite website, downloaded and compiled 2.7.2 on my
laptop. I then did the same test and have the same problem. Running my
laptop's 2.7.2 sqlite on the iPaq's contacts file (using the iPaq's
2.7.2 sqlite) without modifying any data and .quitting causes a binary
file difference on my RH7.2 system. Sending that touched contacts file
back to the iPaq causes the same "Unsupported file format" error.

?

Ted

Joseph J. McCarthy wrote:
> Thats odd. I am in the same situation (2.7.4 on desktop, 2.7.2 on Ipaq)
> and they exchange fine between the two.....?
>
> I guess I can build a new ipk of 2.7.4, but it might not be today....do
> you have access to the development cluster? It isnt too hard to build it
> yourself (I just dont know that I will have time today).
>
> Joe
>
> On Fri, 2003-01-10 at 08:30, Theodore E Poe Jr. wrote:
>
>>Thanks. Unfortunately, sqlite must store its version number within the
>>database file upon touching it. I scp'ed contacts generated on the iPaq
>>using your 2.7.2, browsed the data with my 2.7.4 version without
>>modifying the data, then scp'ed the file back to the iPaq. The binary
>>files differ and gpe-contacts rejected it with "Unsupported file format."
>>
>>Just to make sure, I scp'ed a good contacts file from the iPaq back and
>>forth without touching it with sqlite and it worked fine.
>>
>>Do you know where to get the 2.7.2 source that I could compile for my
>>laptop and hopefully resolve this?
>>
>>Ted
>>
>>Joseph J. McCarthy wrote:
>>
>>>I am uploading a new one now......
>>>
>>>check in unstable in 10 minutes :)
>>>
>>>joe
>>>
>>>
>>>On Thu, 2003-01-09 at 15:39, Theodore E Poe Jr. wrote:
>>>
>>>
>>>>Currently, the sqlite ipkg is version 2.4. Can GPE move up to version
>>>>2.7 so that it can be more current? I have the 2.7.4 rpm on my laptop
>>>>and would like to use evo2gpe.py to load all of my Contacts onto my
>>>>iPaq. (Or else, is the 2.4 source code available to compile that on my
>>>>laptop, instead?)
>>>>
>>>>Thanks.
>>>>
>>>>Ted
>>>>
>>>>_______________________________________________
>>>>GPE mailing list
>>>>GPE_at_handhelds.org
>>>>http://handhelds.org/mailman/listinfo/gpe
>>>
Received on Fri Jan 10 2003 - 13:58:11 EST

This archive was generated by hypermail 2.2.0 : Mon Jul 25 2005 - 17:19:02 EDT