pilot-db-list

[pilot-db-list] Crash by using database

[Kaldewey M. <mal...@si...>]

Hello,
I'm using palm db v 1.0.2 on a palm III xe with palm os 3.5. 

I get a crash during I was editing a small database with 1 field. I've
entered a new data, store them, go to top of the db, sort the database and
then I type an upper V with the pen to jump to the new data. Now my palm
makes an reset. The log from the reset shows the following:

Crash was caused by error "db3.c, line 1373, out of memory" while running
DB.

Whats wrong?

[pilot-db-list] Another windows newbie question

[KANE P. (CA) <Pet...@er...>]

Is there a GUI for development under windows?

This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062
Ergon Energy Pty Ltd      ABN 66 078 875 902

[pilot-db-list] Help - compiling in windows/Cygwin

[KANE P. (CA) <Pet...@er...>]

I'm trying to re-compile DB in windows.

So far, I've installed and configured:
* Cygwin (DLL v 1.3.12-2)
* PRC-Tools (Cygwin installed v2.2 - might be a problem. reference version
is 2.1)
* SDK 4.0 + update (is the update a problem?)

I did the ./configure OK. When I ran the make command, I get the following
message. Can anyone please help me?

$make
/usr/bin/m68k-palmos-gcc -Wall -Werror -02 -g -DGOLBAL_ACCESS -include
"config.h: -c list.c
list.c: In funtion 'ListViewUpdateForm':
list.c: 700: dereferencing pointer to incomplete type
list.c: 750: dereferencing pointer to incomplete type
make: *** [list.o] Error 1


This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062
Ergon Energy Pty Ltd      ABN 66 078 875 902

Re: [pilot-db-list] DB crashes Visor Neo

[Marc C. <mar...@la...>]

David Mayerovitch wrote:
> Marc - Since I posted my message I have found the cause of the problem. I
> have been using with my Visor Neo the plug-in module Thinmodem+, which
> provides a 56k modem plus an extra 8 meg of RAM. When the Thinmodem+ is in
> place and a new Pilot-DB database has been installed during a Hotsync
> operation, the system will crash as soon as I attempt to run the DB program.
> The same thing happens if I create a new database on the Visor.
> 
> There is a way of working around this problem.
> 
> I remove the Thinmodem+ module before installing or creating any new
> database on the Visor. I then reinstall the module and Pilot-DB functions
> normally.
> 
> But what was your idea? And what is a "ROM file" and how do I generate it?

i change the color depth for grayscale, but perhaps there is something 
special for Visor/Prism but now it's a Neo

> 
> Salut.
> David
> 

RE: [pilot-db-list] DB crashes Visor Neo

[David M. <dav...@sy...>]

Marc - Since I posted my message I have found the cause of the problem. I
have been using with my Visor Neo the plug-in module Thinmodem+, which
provides a 56k modem plus an extra 8 meg of RAM. When the Thinmodem+ is in
place and a new Pilot-DB database has been installed during a Hotsync
operation, the system will crash as soon as I attempt to run the DB program.
The same thing happens if I create a new database on the Visor.

There is a way of working around this problem.

I remove the Thinmodem+ module before installing or creating any new
database on the Visor. I then reinstall the module and Pilot-DB functions
normally.

But what was your idea? And what is a "ROM file" and how do I generate it?

Salut.
David

> -----Original Message-----
> From: Marc Chalain [mailto:mar...@la...]
> Sent: 26 Aug 2002 06:35
> To: David Mayerovitch
> Cc: pil...@li...
> Subject: Re: [pilot-db-list] DB crashes Visor Neo
>
>
> David Mayerovitch wrote:
>  > I have a Visor Neo with 8 meg of RAM running PalmOS 3.5.
>  >
>  >
>  >
>  > I installed db-light.prc and it seemed to work well. I then deleted
> it and
>  > tried db.prc. When I tried to run it, the system crashed with a Fatal
> Alert
>  > and I had to reset. I have tried several times to make either db.prc
> or db-
>  > light.prc work. I have been careful to delete any previous installation
>  > using uninstall.prc and/or deleting the application directly.
>  >
>  >
>  >
>  > I am running TealMaster and LapTopHack. I have tried installing db or
>  > db-light with hacks activated or deactivated, but the result
> is the same:
>  > as soon as I try to run the program the system crashes with a Fatal
>  > Alert.
>  >
>  >
>  >
>  > I have seen in various postings elsewhere that other Visor users have
> also
>  >
>  > experienced problems with Pilot-DB.
>  >
>  >
>  >
>  > Can anyone suggest a solution?
>  >
>  >
>  >
>  > David
>  > Mayerovitch
>  > dav...@sy... <mailto:dav...@sy...>
>
>
> I have perhaps an idea. Can you send me your ROM file?
>
> Salut,
> Marc.
>
>

Re: [pilot-db-list] DB crashes Visor Neo

[Marc C. <mar...@la...>]

David Mayerovitch wrote:
 > I have a Visor Neo with 8 meg of RAM running PalmOS 3.5.
 >
 >
 >
 > I installed db-light.prc and it seemed to work well. I then deleted 
it and
 > tried db.prc. When I tried to run it, the system crashed with a Fatal 
Alert
 > and I had to reset. I have tried several times to make either db.prc 
or db-
 > light.prc work. I have been careful to delete any previous installation
 > using uninstall.prc and/or deleting the application directly.
 >
 >
 >
 > I am running TealMaster and LapTopHack. I have tried installing db or
 > db-light with hacks activated or deactivated, but the result is the same:
 > as soon as I try to run the program the system crashes with a Fatal
 > Alert.
 >
 >
 >
 > I have seen in various postings elsewhere that other Visor users have 
also
 >
 > experienced problems with Pilot-DB.
 >
 >
 >
 > Can anyone suggest a solution?
 >
 >
 >
 > David
 > Mayerovitch
 > dav...@sy... <mailto:dav...@sy...>


I have perhaps an idea. Can you send me your ROM file?

Salut,
Marc.

[pilot-db-list] Help. How to start DB development under Windows?

[KANE P. (CA) <Pet...@er...>]

This has probably been asked before, but can some-one please give me some
tips for setting up a development environment for db under windows (NT4, but
soon to be XP pro). I'm interested in developing some apps that utilise a db
database as a back-end (maybe by adding more flexible display screens to
standard db).

This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062
Ergon Energy Pty Ltd      ABN 66 078 875 902

Re: [pilot-db-list] Problem viewing bottom half of list

[Fab <kr...@fr...>]

> >> I have 4 pilot-db 2 I created from scratch and 2 I downloaded (in mobile DB
> >> format)
> >> 
> >> When I display them in list mode and click near the bottom of the list the
> >> records below a certain record are not selected (which enters you into
> >> detail mode) it does the "flash" but that is it. It doesn't matter which
> >> order I sort the database in. If I goto to edit mode by selection a record
> >> above the "bad" records and select down I can get to the "bad" records and
> >> every thing is fine.
> >> Has anybody had this problem?
> >> Handspring Treo 270
> > Which version of db do you use ?
> > How did you install it ?
> Version 1.0.2 of pilot-db
> Installed from Macintosh OS 9 using Palm Desktop 2.6

        So it seems the problem occurs only with your PDA.
        Which version of Palm OS dos it show ?
        I'm sorry, but I think you must wait until the return of
Mark to solve this problem.

        Fab.

Re: [pilot-db-list] Problem viewing bottom half of list

[Fab <kr...@fr...>]

> I have 4 pilot-db 2 I created from scratch and 2 I downloaded (in mobile DB
> format)
> 
> When I display them in list mode and click near the bottom of the list the
> records below a certain record are not selected (which enters you into
> detail mode) it does the "flash" but that is it. It doesn't matter which
> order I sort the database in. If I goto to edit mode by selection a record
> above the "bad" records and select down I can get to the "bad" records and
> every thing is fine.
> 
> Has anybody had this problem?
> Handspring Treo 270


	Which version of db do you use ?
	How did you install it ?

	Fab.

[pilot-db-list] Re: =?iso-8859-1?Q?=5Bpilot-db-list=5D_db-0=5F3=5F3-fr_+_les_fonctions_suiva?= =?iso-8859-1?Q?ntes_=3D_=3F_r=E9f=2C_prix_=3F?=

[Fab <kr...@fr...>]

	This an international mailing list. So please,
use english language.


> Là je rêve ! J et conçoit bien qu'un freeware

	Pilot-db isn't just a freeware but an open source
software. There is no commercial business under it. Go to

<http://sourceforge.net/projects/pilot-db/>

read the principles and fetch the last version.


> Fonctions souhaitées :
> - Pouvoir modifier un type Liste, sans être obligé de la refaire entièrement

	You can with the last version.


> - Disposer d'un type, « Liste à choix multiples » avec une sous liste à choix multiple paramétrable comme la 1ère, déroulante, pour chaque item de la liste » +++

	No way actually.


> - Disposer de plusieurs, type « Notes », par base
> - Disposer de plusieurs filtres en même temps

	You can with the last version.
	

> - Pouvoir nommer les filtres, de façon à  choisir dans la liste déroulante, le ou les filtres créés ( on souvient pas à quoi correspond filtre 1, 2 .)

	This is in the todo. Wait for a next version (No
commercial, no date).


> - Atteindre dans la liste des fiches, le champ correspondant au filtre sélectionné 

	Create a special vue.


> - Disposer d'un module statistique permettant de connaître le % des fiches / total, correspondant aux filtres sélectionnés. 

	Good idea for a plugin.


> - Pouvoir importer dans une base une fiche d'une autre base de même structure (duplicata)


> - Pouvoir sauvegarder, lire et éditer les BD sur le PC, après conversion .pdb <> .txt ou mieux .doc et HotSync. 

	Fetch the pilot-db tools.


> -         définition de All Fields et de Tout ??

	You can't modify the default "all fields" view. You must
create a new view with your needs.

> _ Je n'ai pas plus de succès avec la fonction Tri 
> Trier quoi : l'ordre des champs dans la base je suppose, ou les fiches ?

	The records in the "view". Not in the database.


> - on choisi à droite le champ a partir duquel on veut modifier l'ordre
	
	On the right you select the fields on which you want
to sort the records in the current view. On the left you can
add more fields to create segmented sort keys. And you have 
2 checkboxes per field : ascending or descending order, Case
Sensitive or not.

	HTH.

	Fab.

Re: [pilot-db-list] Pilot DB

[Fab <kr...@fr...>]

> >Bonjour,

	Salut les gars.


	You are on an international mailing list. So the prefered
language is english. It's better ask questions in that language
because more people will be able to answer them :-)


> Avez-vous désinstallé complètement DB avant d'installer la dernière
> version (1.0.2) ? Il faut ensuite réinstaller les bases depuis le
> répertoire Backup.

	This last version include a little Palm program to fully
uninstall previous version. Try to use it.

> >J'aurais aussi besoin de précisions sur les filtres
> là je sèche. Je ne comprends pas comment on accede aux filtres. les
> captures d'écran dans la doc ne correpondent pas à ce que je vois.

	What do you see ?


> > D'autres éditeur de bases de données sur Palm, offrant plus de possibilités ? : choix multiples de détails (case à cocher) ,
> note...pour chaque champs, plus de champs...par exemple

	You can achieve multiple toggle buttons by creating...
multiple "check" fields. There is actually no "note" to describe
fields. But the "note" type is handled by cd. What do you mean by
"plus de champs" ?

	Fab.

[pilot-db-list] Problem viewing bottom half of list

[Don M. <don...@ma...>]

I have 4 pilot-db 2 I created from scratch and 2 I downloaded (in mobile DB
format)

When I display them in list mode and click near the bottom of the list the
records below a certain record are not selected (which enters you into
detail mode) it does the "flash" but that is it. It doesn't matter which
order I sort the database in. If I goto to edit mode by selection a record
above the "bad" records and select down I can get to the "bad" records and
every thing is fine.

Has anybody had this problem?

Handspring Treo 270


Don Myers

[pilot-db-list] =?iso-8859-1?Q?db-0=5F3=5F3-fr_+_les_fonctions_suivantes_=3D_=3F_r=E9f=2C?= =?iso-8859-1?Q?_prix_=3F?=

[Jean-Bernard B. <jb...@wa...>]

Bonjour,=20

Apr=E8s la r=E9alisation de ma 1=E8re BD,  avec votre db-0_3_3-fr, j'ai =
fait une liste des fonctions qui me seraient bien utiles.

L=E0 je r=EAve ! J et con=E7oit bien qu'un freeware ne peut offrir tout =
=E7a. Mais je suis pr=EAt =E0 payer une application comme le votre avec =
ces fonctions en plus et peut =EAtre d'autres, dont je ne soup=E7onne =
pas encore l'int=E9r=EAt.
Je suppose que ce freeware est un produit d'appel et que vous proposez, =
des  Plugins, ou d'autres =E9diteurs de BD fonctionnant sur OS , plus =
complets ? r=E9f=E9rences ? prix ?
En tout cas cet outil que je d=E9couvre avec l'acquisition d'un nouveau =
Palm m515 sur Wxp, m'appara=EEt indispensable dans ma vie =
professionnelle (ophtalmo) et priv=E9e

=20

Fonctions souhait=E9es :

- Pouvoir modifier un type Liste, sans =EAtre oblig=E9 de la refaire =
enti=E8rement

- Disposer d'un type, =AB Liste =E0 choix multiples =BB avec une sous =
liste =E0 choix multiple param=E9trable comme la 1=E8re, d=E9roulante, =
pour chaque item de la liste =BB +++

- Disposer de plusieurs, type =AB Notes =BB, par base

- Disposer de plusieurs filtres en m=EAme temps

- Am=E9liorer la s=E9lection des filtres en ajoutant un bouton qui =
d=E9roule la liste du "champs Liste" s=E9lectionn=E9
- Pouvoir nommer les filtres, de fa=E7on =E0  choisir dans la liste =
d=E9roulante, le ou les filtres cr=E9=E9s ( on souvient pas =E0 quoi =
correspond filtre 1, 2 .)

- Atteindre dans la liste des fiches, le champ correspondant au filtre =
s=E9lectionn=E9=20

- Disposer d'un module statistique permettant de conna=EEtre le % des =
fiches / total, correspondant aux filtres s=E9lectionn=E9s.=20

- Pouvoir importer dans une base une fiche d'une autre base de m=EAme =
structure (duplicata)
- Pouvoir sauvegarder, lire et =E9diter les BD sur le PC, apr=E8s =
conversion .pdb <> .txt ou mieux .doc et HotSync.=20


Parmi ces fonctions, que permet la version db-0_3_3 ?=20



En attendant, existe t'il un mode d'emploi plus pr=E9cis, =E0 imprimer =
sur votre site: les copies d'=E9cran sont lourdes et ne remplacent pas =
une proc=E9dure bien d=E9tall=E9e :=20

=20

_ Editer des Vues par exemple, n'est pas du tout clair pour moi

-         but : s=E9lectionner une Vues dans la liste d=E9roulante, pour =
qu'elle s'affiche dans l'=E9cran liste des fiches ?

-         d=E9finition de All Fields et de Tout ??

-         Editer Vues > DB : Vues / S=E9lection All Fields / Editer/ =
Remplacer All Fields par le nom de la vue donnant acc=E8s au(x) champs =
que l'on souhaite voir appara=EEtre =E0 l'=E9cran, de liste des fiches / =
Cocher la case =AB Utiliser cette vue pour voir un enregistrement =BB : =
enregistrement ? =3D champs ou un groupe de champs ?

-         J'ai auparavant r=E9gl=E9 la largeur des colonnes de champs en =
veillant =E0 ce que la sommes des largeurs de champs voisins soit =
=E9gale =E0 160 pour =EAtre visibles ensembles sur un =E9cran de liste =
des fiches

-         S=E9lection du ou des champs de la vue / fermer / Nouveau ..

Ca ne marche pas : la s=E9lection d'une vue n'am=E8ne pas l'=E9cran des =
fiches sur le champs souhait=E9s (mais est ce vraiment le but ?), il =
reste sur les 1er champs.

=20

_ Je n'ai pas plus de succ=E8s avec la fonction Tri=20

Trier quoi : l'ordre des champs dans la base je suppose, ou les fiches ?

Comment =E7a marche ? s=E9quence des actions

- on choisi =E0 droite le champ a partir duquel on veut modifier l'ordre
- =E0 gauche insertion apr=E8s le champ suivant .
Ca ne marche pas, car je ne saisi pas bien la fonction des 2 cases =E0 =
cocher

Signification de ORT_LABEL_CS !?

Merci pour vos r=E9ponses

Dr JB Borye
jb...@wa...

Re: [pilot-db-list] Pilot DB

[Thomas R. <tr...@or...>]

>Bonjour,
>Mes  bases sont pr=EAtes, mais je coince sur les vues
>Dans l'=E9diteur, je fais nouveau, s=E9lectionne AllFields, Editer, je n=
omme la vue, coche la case, r=E8gle la largeur des colonnes des champs vo=
isins s=E9lectionn=E9s (est il n=E9cessaire que leur somme soit inf=E9rie=
ure ou =E9gale =E0 160 ?). Une barre verticale appara=EEt =E0 gauche. Fer=
mer=20
>Le nom de la vue appara=EEt bien dans la liste mais sa s=E9lection n' af=
fiche pas ses champs et les 1er champs sont toujours affich=E9s.

C'est assez curieux. Les vues fonctionnent tr=E8s bien chez moi.Il n'est =
pas
n=E9cessaire que le total fasse moins de 160 pixels.
Avez-vous d=E9sinstall=E9 compl=E8tement DB avant d'installer la derni=E8=
re
version (1.0.2) ? Il faut ensuite r=E9installer les bases depuis le
r=E9pertoire Backup.

>J'aurais aussi besoin de pr=E9cisions sur les filtres

l=E0 je s=E8che. Je ne comprends pas comment on accede aux filtres. les
captures d'=E9cran dans la doc ne correpondent pas =E0 ce que je vois.

>Un mode d'emploi plus pr=E9cis que celui que l'on peut ouvrir, est 'il d=
isponible sur le web ?

Le mode d'emploi le plus =E0 jour je pense est celui en francais disponib=
le
sur le site http://pilot-db.sourceforge.net/ dans la cat=E9gorie download
sous le nom pilot-db-docfr.html.zip et dat=E9e du 17 juin.

>Existet'il des plugins ? Une version plus r=E9cente que 0.3.3 de12/01 ?

toujours dans la page download, en bas, le fichier db-plugins-1_0_0.zip
date du 7 mars 2002.

> D'autres =E9diteur de bases de donn=E9es sur Palm, offrant plus de poss=
ibilit=E9s ? : choix multiples de d=E9tails (case =E0 cocher) , note...po=
ur chaque champs, plus de champs...par exemple

DB g=E8re les champs Note et Liste (=E9num=E9r=E9) mais ce n'est peut etr=
e pas de
=E7a dont vous parliez.
Il existe d'autres applis de base de donn=E9es, shareware ou commerciaux,
mais pas forcement mieux (=E0 voir). En vrac: Handbase, Jfile, MobileDB,
ThinkDB (voir http://www.izipalm.com/bd.htm).=20

>Merci pour votre r=E9ponse;
>
>JB Borye
>jb...@wa...
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by: OSDN - Tired of that same old
>cell phone?  Get a new here for FREE!
>https://www.inphonic.com/r.asp?r=3Dsourceforge1&refcode1=3Dvs3390
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list

[pilot-db-list] Pilot DB

[Jean-Bernard B. <jb...@wa...>]

Bonjour,
Mes  bases sont pr=EAtes, mais je coince sur les vues
Dans l'=E9diteur, je fais nouveau, s=E9lectionne AllFields, Editer, je =
nomme la vue, coche la case, r=E8gle la largeur des colonnes des champs =
voisins s=E9lectionn=E9s (est il n=E9cessaire que leur somme soit =
inf=E9rieure ou =E9gale =E0 160 ?). Une barre verticale appara=EEt =E0 =
gauche. Fermer=20
Le nom de la vue appara=EEt bien dans la liste mais sa s=E9lection n' =
affiche pas ses champs et les 1er champs sont toujours affich=E9s.
J'aurais aussi besoin de pr=E9cisions sur les filtres
Un mode d'emploi plus pr=E9cis que celui que l'on peut ouvrir, est 'il =
disponible sur le web ?
Existet'il des plugins ? Une version plus r=E9cente que 0.3.3 de12/01 ? =
D'autres =E9diteur de bases de donn=E9es sur Palm, offrant plus de =
possibilit=E9s ? : choix multiples de d=E9tails (case =E0 cocher) , =
note...pour chaque champs, plus de champs...par exemple
Merci pour votre r=E9ponse;

JB Borye
jb...@wa...

Re: [pilot-db-list] Delete list from DB-pilot

[Kelly S. H. <sh...@mo...>]

The "create database" function was added twice... :)
You can access it from "New" in the menu or
from the little ">*" icon on the bottom...

-Shane

----- Original Message ----- 
From: "Marc Chalain" <mar...@la...>
To: "Kelly Shane Harrelson" <sh...@mo...>
Cc: <pil...@li...>
Sent: Monday, August 05, 2002 4:07 AM
Subject: Re: [pilot-db-list] Delete list from DB-pilot


> I'm sorry but i will not add twice the same function. To rename a 
> database you must select the database and that means to add a new 
> dialogbox if i implement this in the menu.
> I wrote a documentation where the icon menu is explained!
> 
> Kelly Shane Harrelson wrote:
> > It might be a nice idea to add these commands to 
> > the menu as well...
> > -Shane
> > 
> > ----- Original Message ----- 
> > From: "Walter Koch" <ko...@u3...>
> > To: <pil...@li...>
> > Sent: Saturday, August 03, 2002 5:42 AM
> > Subject: Re: [pilot-db-list] Delete list from DB-pilot
> > 
> > 
> > 
> >>Moin,
> >>
> >>Du schriebst am / on Wed, 31 Jul 2002 12:08:59 -0400 you wrote:
> >>
> >>
> >>>1) Is it possible to delete a database from the list ?
> >>>2) Is it possible to rename a database ?
> >>
> >>Both can be done by taping the icon right of the database name. 
> >>
> >>Gruss,
> >>  Walter
> >>
> >>-- 
> >>  Hochdahl am Neandertal
> >>
> >>
> >>-------------------------------------------------------
> >>This sf.net email is sponsored by:ThinkGeek
> >>Welcome to geek heaven.
> >>http://thinkgeek.com/sf
> >>_______________________________________________
> >>Pilot-db-list mailing list
> >>Pil...@li...
> >>https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> >>
> > 
> > 
> > 
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Pilot-db-list mailing list
> > Pil...@li...
> > https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> > 
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

[pilot-db-list] feature requests for pilot-db (and java csv importer)

[Daniel L. <spr...@PA...>]

Hello:

I am using the java csv importer program to convert shortwave broadcast 
schedules to a pilot-db usable form.  I have two feature requests for 
the developers:

1) Would it be possible to somehow "tie" a default sorting scheme to 
each view?  In the database I am using (Prime Time Shortwave), I have 
constructed two views, viewing the schedule by UTC time and viewing it 
by Country of origin.  When the user selects the "By Time" view I would 
like pilot-db to automatically sort by time, and when the user selects 
"By Country" I would like pilot-db to automatically sort by Country.  In 
addition, it would be cool if you could specify a default sorting scheme 
on a "view" line in the csv importer's config file.

2) Speaking of the csv importer config file, I would like to be able to 
include some kind of credits for the originator of the database, 
including copyright and version information.  It would be nice if you 
could somehow tell the csv importer to read the first N lines of the csv 
file as "database credits"  There could be a menu entry under pilot-db's 
"Help" that says "About this Database."  When the user clicks on this 
menu entry, the database credits appear.  This would probably require 
changes to both the pilot-db program on the PalmOS device and the java 
csv importer.

Would this stuff be really hard to implement?

Thanks,
Dan
-- 
Daniel Lyddy		spr...@pa...

[pilot-db-list] DB crashes Visor Neo

[David M. <dav...@sy...>]

I have a Visor Neo with 8 meg of RAM running PalmOS 3.5.

I installed db-light.prc and it seemed to work well. I then deleted it
and
tried db.prc. When I tried to run it, the system crashed with a Fatal
Alert
and I had to reset. I have tried several times to make either db.prc or
db-
light.prc work. I have been careful to delete any previous installation
using uninstall.prc and/or deleting the application directly.

I am running TealMaster and LapTopHack. I have tried installing db or
db-light with hacks activated or deactivated, but the result is the
same:
as soon as I try to run the program the system crashes with a Fatal
Alert.

I have seen in various postings elsewhere that other Visor users have
also
experienced problems with Pilot-DB.

Can anyone suggest a solution?

David
Mayerovitch
dav...@sy...

Re: [pilot-db-list] view/search on adress category

[Scott W. <swa...@my...>]

On Fri, 16 Aug 2002, Karl Broich wrote:

Karl, sadly I don't think anything can be done at this point.  The=20
addressdb driver (which reads the adress data) is very limited, and I=20
believe was really only meant for linking records into another database=20
using the link/linked fields.

To produce new views would would either require converting the address db=
=20
into db native format (thus replicating all of your addresses).  You=20
could, then remove all the data from the adress application, but of cours=
e=20
then you would need to use db just to look up someone's phone number.

In the future, the addressdb driver could be improved to add this=20
functionality.  But this is not a top priority, and developer time is=20
severely limited (perhaps you know of some students who would like to hel=
p=20
with development ;)   )

  -Scott

> Hallo to all list members!
>=20
> I  want to extract a view on a certain category within "adress" (standa=
rd=20
> palm application). Within this view I want to list records matching a=20
> certain string within a chosen field. I want to edit and input the adre=
sses=20
> using "adress". Therefore there is no need for the db-pilot application=
 to=20
> modify the data.
>=20
> I tried to use adressDB, but I failed in the beginning, because :
> 1. adressDB just shows _all_ categories and there seems to be no way to=
=20
> show just the category I need.
> 2. adressDB seems not allow for user defined views
>=20
> Then I tried linking a new database to adressDB in order to be able to =
use=20
> some user defined  view. But then I found that the links has to be defi=
ned=20
> for each record. That is far to cumbersome, because this doubles work f=
or=20
> data input (as well as expensive data space on my palm) .
>=20
> Can anyone give some hints what can be done?
>=20
> Thanks!
>=20
> Karl
>=20
>=20
> -----------------------------------------------------------------------=
---
> Dr.-Ing. Karl BROICH			Tel:	+49 / (0) 89 / 6004 2478
> Universit=E4t der Bundeswehr M=FCnchen	Fax:	+49 / (0) 89 / 6004 3858
> Institut f=FCr Wasserwesen
> Werner-Heisenberg-Weg 39
> D 85577 Neubiberg
> -----------------------------------------------------------------------=
---
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone?  Get a new here for FREE!
> https://www.inphonic.com/r.asp?r_______________________________________=
________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>=20

--=20

Re: [pilot-db-list] JFile4/5

[Scott W. <swa...@my...>]

Currently we cannot convert from Jile4/5 format to db format.  This would 
require a new driver, and developer time is (obviously) severely limited. 
If anyone would like to volunteer, it would be a good way to learn how to 
program using the Palm SDK, and it would be a well defined an manageable 
project.


	-Scott

Re: [pilot-db-list] unable to open database

[Scott W. <swa...@my...>]

On Mon, 12 Aug 2002, The Williams wrote:

> My palm crashed  (IIIxe  Palm OS 3.5.0) and post backup cannot open my 
> databases  Reloaded DB 0.3.3 twice and tried new version with no success 
>  What am i doing wrong?  Many thanks

What happens?  In what way won't DB open your reloaded databases?  If they 
just don't show up in the chooser, you might try the 'Rescan databases' 
menu item.

	-Scott

[pilot-db-list] view/search on adress category

[Karl B. <b6...@B6...>]

Hallo to all list members!

I  want to extract a view on a certain category within "adress" (standard=20
palm application). Within this view I want to list records matching a=20
certain string within a chosen field. I want to edit and input the adresses=
=20
using "adress". Therefore there is no need for the db-pilot application to=
=20
modify the data.

I tried to use adressDB, but I failed in the beginning, because :
1. adressDB just shows _all_ categories and there seems to be no way to=20
show just the category I need.
2. adressDB seems not allow for user defined views

Then I tried linking a new database to adressDB in order to be able to use=
=20
some user defined  view. But then I found that the links has to be defined=
=20
for each record. That is far to cumbersome, because this doubles work for=20
data input (as well as expensive data space on my palm) .

Can anyone give some hints what can be done?

Thanks!

Karl


--------------------------------------------------------------------------
Dr.-Ing. Karl BROICH			Tel:	+49 / (0) 89 / 6004 2478
Universit=E4t der Bundeswehr M=FCnchen	Fax:	+49 / (0) 89 / 6004 3858
Institut f=FCr Wasserwesen
Werner-Heisenberg-Weg 39
D 85577 Neubiberg
--------------------------------------------------------------------------

[pilot-db-list] SUM, COUNT, AVERAGE

[Ng, M. F. <Man...@ma...>]

Hi

I am a new user to Pilot-DB v1.0.2 on HE330. I need help on the following
area:

a. SUM (a column/field)
b. COUNT (number of record)
c. AVERAGE (a column/field)

1) I hv created a database with a field of type: FLOAT
2) after entering several records, I would like to find out the total value
for all the records entered i.e. like:

select count(field1)
from db-Test

Can anybody pse give me some detail.

Thk in adv.

[pilot-db-list] =?ISO-8859-1?B?UGV0ZXIgVCBTcHJlbmdlci8wNTAvRENBRy9EQ1ggaXN0IGF132VyIA==?=Haus.

[<pet...@da...>]

Ich werde ab  12.08.2002 nicht im B=FCro sein. Ich kehre zur=FCck am  0=
4.09.2002.

=

[pilot-db-list] Pilot-DB v1.0.2 - bug report

[Leblanc, N. (N.J.) <nle...@ja...>]

Hi,

I have been using Pilot-DB for a couple of weeks now and I think it's the
best software I have installed on my Palm m515. It is so flexible, it is
nearly perfect. I say nearly perfect because I have come across a bug
several times (pretty much every day in fact) : this occurs when I am trying
to update a record. 

I have created a database with some records, and saved it. I then go back
into the database, select a record in order to update it. Once I am in the
record page, I click the "edit" icon (bottom middle) and start changing the
content of some of the fields. That works fine. The bug occasioanlly occurs
when I try to save the record : I click on the "save" icon (bottom left) and
sometimes it works great (it returns to the list of records in the
database), but sometimes I get a Fatal Alert window containing the following
message : "DataMgr.c, Line:7386, DmWrite:DmWriteCheck failed" which freezes
the Palm forcing me to do a soft reset.

When I do the soft reset and return to the database, the records are
unchanged except for the one I was updating. For that record, some of the
field contents remain unchanged, some have the first letters deleted
(example an entry that had "tuesday" becomes "sday") and some have been
replaced with content from the lines above.

This is not a big problem and I wanted to report it to you. Please let me
know if I am doing something wrong provoking this, or if you are aware of a
fix.

I hope you keep developping this great tool.

Thanks
Nick

-----------
Regards,
                                       
Nicolas Leblanc
W/1/012 - CAE - Body Engineering - Jaguar Cars Ltd