Subject RE: [firebird-support] Re: firebird, ibreplicator and pda
Author Alan McDonald
> > Hi,
> >
> > From: "martinthrelly"
> >
> > |is it possible to install the firebird database on a PDA?
> >
> > I don't think there is an FB build for ARM cpu/Windows Mobile OS,
> > so...
> > Unless u get to compile one, than it isn't.
> >
> >
> > Regards,
> > Anderson
> >
>
> hello, and thanks for your reply. what are my options then?
> to run the PDA database as something else and somehow sync
> this with Firebird afterwards?
>
> thanks

With my Palm apps I have written a dll to run on the sync. It uses
interclient (jayboss) to sync with a firebird database.
But I wrote the Palm app and I use the native datbase manager of Palm.
Unfortunately windows mobile does not come with a native database, you'll
have to use a third party, of which there are many. But the solution wold be
the same. The pda works with it's database the way it likes to and the
firebird database is synced by your app which has to load with activesync. I
have not done an activesync one. The palm one was reasonably trivial but
time consuming. The nice thing about the Palm database manager is the fact
that all records are tagged so you can quickly return all changed records,
sync them and untag them. You'd have to do the same sort of thing with
whatever 3rd party database you use, yourself.
The other protocol I used whih suited me, was that everytime a worker went
into the field they would download a fresh copy of the view of data they
wiched to use, then on return they would sync their changes and optionally
delete there data.

Alan