pilot-db-list

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

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

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.

thanks.

Jon

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

[<di...@ta...>]

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.

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

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
>

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

[<di...@ta...>]

On Thu, Jun 02, 2005 at 05:34:16PM +0100, Jonathan Fitt wrote:
> 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.

It's not possible, as far as I understand. I do not know how much work
it would take to make it possible - it might not be that much work.
-- 
Didi

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

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

On 6/2/05, Yedidyah Bar-David <di...@ta...> wrote:
> On Thu, Jun 02, 2005 at 05:34:16PM +0100, Jonathan Fitt wrote:
> > 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.
>=20
> It's not possible, as far as I understand. I do not know how much work
> it would take to make it possible - it might not be that much work.

I've worked out how I would do it. I can make a linked field which
points to the dozens field in the record the original link field
points to. I can them have my percentage field take the value from the
linked field, and the number of hits, and display a percentage.

I have a new question though:
Is it possible to get back into the calculated field definition after
setting it? The only way I can get back in is by changing the field
type to something else, and then back to calculated. However this
deletes its contents.

Also, what do global scripts do, and what is an example use for them?

Thanks,

Jonathan

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

[<di...@ta...>]

On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote:
> I have a new question though:
> Is it possible to get back into the calculated field definition after
> setting it? The only way I can get back in is by changing the field
> type to something else, and then back to calculated. However this
> deletes its contents.

Simply choose again 'calculated'. That is, tap the already-selected
'Calculated' option.

> 
> Also, what do global scripts do, and what is an example use for them?

Look at docs/scripts.txt. IIRC the only use is to run one when selecting
a view - e.g. to automatically sort the rows when entering a specific
view.
-- 
Didi

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

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

On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote:
> On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote:
> > I have a new question though:
> > Is it possible to get back into the calculated field definition after
> > setting it? The only way I can get back in is by changing the field
> > type to something else, and then back to calculated. However this
> > deletes its contents.
>=20
> Simply choose again 'calculated'. That is, tap the already-selected
> 'Calculated' option.

I've tried that, it closes the selction box, but the script edit
window does not appear. The only way I can get it to appear is to
select another type e.g. string, and then select calculated again.
=20
> >
> > Also, what do global scripts do, and what is an example use for them?
>=20
> Look at docs/scripts.txt. IIRC the only use is to run one when selecting
> a view - e.g. to automatically sort the rows when entering a specific
> view.

The scripts section in the manual doesn't go into global scripts. Is
the only possible command the sort command?
I would have thought that a script used at that time would be used to
select records to view, and then sort them. So that you could find all
records containing the name Adam, and sort them by age, for example.

Jon

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

[<di...@ta...>]

On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote:
> On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote:
> > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote:
> > > I have a new question though:
> > > Is it possible to get back into the calculated field definition after
> > > setting it? The only way I can get back in is by changing the field
> > > type to something else, and then back to calculated. However this
> > > deletes its contents.
> > 
> > Simply choose again 'calculated'. That is, tap the already-selected
> > 'Calculated' option.
> 
> I've tried that, it closes the selction box, but the script edit
> window does not appear. The only way I can get it to appear is to
> select another type e.g. string, and then select calculated again.

Well, this might be a change from 1.1.0, which is the version I use.
Can you try and check?

>  
> > >
> > > Also, what do global scripts do, and what is an example use for them?
> > 
> > Look at docs/scripts.txt. IIRC the only use is to run one when selecting
> > a view - e.g. to automatically sort the rows when entering a specific
> > view.
> 
> The scripts section in the manual doesn't go into global scripts. Is

It's not in the user manual. Look at docs/scripts.txt.

> the only possible command the sort command?
> I would have thought that a script used at that time would be used to
> select records to view, and then sort them. So that you could find all
> records containing the name Adam, and sort them by age, for example.

It does have also a filter.
-- 
Didi

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

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

On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote:
> On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote:
> > On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote:
> > > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote:
> > > > I have a new question though:
> > > > Is it possible to get back into the calculated field definition aft=
er
> > > > setting it? The only way I can get back in is by changing the field
> > > > type to something else, and then back to calculated. However this
> > > > deletes its contents.
> > >
> > > Simply choose again 'calculated'. That is, tap the already-selected
> > > 'Calculated' option.
> >
> > I've tried that, it closes the selction box, but the script edit
> > window does not appear. The only way I can get it to appear is to
> > select another type e.g. string, and then select calculated again.
>=20
> Well, this might be a change from 1.1.0, which is the version I use.
> Can you try and check?

I'm running 1.1.3. I don't really want to go backwards as it is
working at the moment. Could it be a device issue? I'm on an old Palm
V.
=20
> >
> > > >
> > > > Also, what do global scripts do, and what is an example use for the=
m?
> > >
> > > Look at docs/scripts.txt. IIRC the only use is to run one when select=
ing
> > > a view - e.g. to automatically sort the rows when entering a specific
> > > view.
> >
> > The scripts section in the manual doesn't go into global scripts. Is
>=20
> It's not in the user manual. Look at docs/scripts.txt.

I'm probably missing something, but I have no docs/scripts.txt all the
documentation is in html, and it's the same as the user manual online.
=20
Jon

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

[<di...@ta...>]

On Tue, Jun 07, 2005 at 10:52:45AM +0100, Jonathan Fitt wrote:
> On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote:
> > On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote:
> > > On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote:
> > > > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote:
> > > > > I have a new question though:
> > > > > Is it possible to get back into the calculated field definition after
> > > > > setting it? The only way I can get back in is by changing the field
> > > > > type to something else, and then back to calculated. However this
> > > > > deletes its contents.
> > > >
> > > > Simply choose again 'calculated'. That is, tap the already-selected
> > > > 'Calculated' option.
> > >
> > > I've tried that, it closes the selction box, but the script edit
> > > window does not appear. The only way I can get it to appear is to
> > > select another type e.g. string, and then select calculated again.
> > 
> > Well, this might be a change from 1.1.0, which is the version I use.
> > Can you try and check?
> 
> I'm running 1.1.3. I don't really want to go backwards as it is
> working at the moment. Could it be a device issue? I'm on an old Palm
> V.

I don't think it's the device. It used to work for me on a VX.

>  
> > >
> > > > >
> > > > > Also, what do global scripts do, and what is an example use for them?
> > > >
> > > > Look at docs/scripts.txt. IIRC the only use is to run one when selecting
> > > > a view - e.g. to automatically sort the rows when entering a specific
> > > > view.
> > >
> > > The scripts section in the manual doesn't go into global scripts. Is
> > 
> > It's not in the user manual. Look at docs/scripts.txt.
> 
> I'm probably missing something, but I have no docs/scripts.txt all the
> documentation is in html, and it's the same as the user manual online.

Sorry. Look at docs under the source directory. It's different from the
binary distribution.
-- 
Didi

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

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

On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote:
> On Tue, Jun 07, 2005 at 10:52:45AM +0100, Jonathan Fitt wrote:
> > On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote:
> > > On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote:
> > > > On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote:
> > > > > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote:
> > > > > > I have a new question though:
> > > > > > Is it possible to get back into the calculated field definition=
 after
> > > > > > setting it? The only way I can get back in is by changing the f=
ield
> > > > > > type to something else, and then back to calculated. However th=
is
> > > > > > deletes its contents.
> > > > >
> > > > > Simply choose again 'calculated'. That is, tap the already-select=
ed
> > > > > 'Calculated' option.
> > > >
> > > > I've tried that, it closes the selction box, but the script edit
> > > > window does not appear. The only way I can get it to appear is to
> > > > select another type e.g. string, and then select calculated again.
> > >
> > > Well, this might be a change from 1.1.0, which is the version I use.
> > > Can you try and check?
> >
> > I'm running 1.1.3. I don't really want to go backwards as it is
> > working at the moment. Could it be a device issue? I'm on an old Palm
> > V.
>=20
> I don't think it's the device. It used to work for me on a VX.
>=20
> >
> > > >
> > > > > >
> > > > > > Also, what do global scripts do, and what is an example use for=
 them?
> > > > >
> > > > > Look at docs/scripts.txt. IIRC the only use is to run one when se=
lecting
> > > > > a view - e.g. to automatically sort the rows when entering a spec=
ific
> > > > > view.
> > > >
> > > > The scripts section in the manual doesn't go into global scripts. I=
s
> > >
> > > It's not in the user manual. Look at docs/scripts.txt.
> >
> > I'm probably missing something, but I have no docs/scripts.txt all the
> > documentation is in html, and it's the same as the user manual online.
>=20
> Sorry. Look at docs under the source directory. It's different from the
> binary distribution.

Ah, that's much better. It has a section on Global scripts, and the
MathLib functions, and a statement on script length which has got me
before.

Thanks,

Jon