Re: [pilot-db-list] Fatal Error with one particular PDB

[Jonathan F. <jo...@gm...>]

Thanks. Clearing up that malformed view sorted it.

I have a more complicated question.
I have a databse which contains archery rounds (the one I sent) and
the number of dozen arrows each entails. I also have a database of my
scores. One of the fields in the score database is a link to the
rounds database so that I can select a round name. In my score
database I have the number of hits. I want to take this and the number
of dozen field from the corresponding record in the round database and
work out my hit percentage as a calculated field. Is this possible?
Basically in my record I want to read a field from another record
linked to by a field in the record.

Thanks again.

On 6/2/05, Yedidyah Bar-David <di...@ta...> wrote:
> On Thu, Jun 02, 2005 at 04:57:32PM +0100, Jonathan Fitt wrote:
> > Hello all,
> >
> > I'm having problems with the attached PDB. I originally had it working
> > without the last column. I recreated it using JPilot-DB from a csv
> > where I had added the last column. Since then it has thrown a fatal
> > error everytime I try and open it. I've tried recreating it afresh,
> > reinstalling Pilot-DB, everything I can think of, but it keeps
> > throwing the error.
> > Any ideas?
> >
> > On a side note I've not had much luck editing schema and or records
> > with JPilot-DB. It doesn't seem to accept changes, hence me recreating
> > the db from a csv file.
>=20
> I suggest you try using palm-db-tools. I tried pdb2csv on the db you
> attached, and it worked well. It outputed an inf file with a line
> view "newview"
> which is invalid. I can't know what exactly was the reason - maybe
> you did not define the view well or there is some other problem. If
> I delete this line and csv2pdb, pilot-db can open the generated db.
> --
> Didi
>=20
>