Re: [Q] SQLITE version

This is very odd since I have never had a problem with the upgrade. it
sounds like you might have gotten caught in a weird "no mans land" where
you were using both 2.7.x and 2.4.10 and now it is slightly hosed.

If you use "less" to look at the file do you see:

** This file contains an SQLite 2.1 database **

at the top?

BTW, I am building a 2.7.4 and will upload it sometime today, just in
case.

Joe

On Fri, 2003-01-10 at 08:56, Theodore E Poe Jr. wrote:
> 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
> >>>
>
>
> _______________________________________________
> GPE mailing list
> GPE_at_handhelds.org
> http://handhelds.org/mailman/listinfo/gpe

-- 
Joseph J. McCarthy, Assistant Professor
Department of Chemical and Petroleum Engineering
University of Pittsburgh
1249 Benedum Hall Pittsburgh, Pennsylvania 15261
Ph. 412-624-7362
Fax 412-624-9639
mccarthy_at_engrng.pitt.edu
http://granular.che.pitt.edu