pilot-db-list

Re: [pilot-db-list] record display/layout hints

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

>matching entry field. It would be nice to at the very least have
>"headers" which would group items. For example, if I'm converting a
>paper form that has a layout like this:

>Foo
>  Number  ___
>  Size    ___
>  Quality ___
>
>Bar
>  Number  ___
>  Size    ___
>  Quality ___

	I like this idea, and had been thinking about something fairly
similar. I have a few ideas for you:

	Instead of defining all the headers int the csv file, or when the
database schema is created, it would be cool (and I don't think too hard)
to do this dynamically.

	So if you have some records:
	<name>	<number>  <size> <quality>
	Foo	10	  big	 high
	Foo 	12	  small  low
	Bar	11	  big	 low
	Bar	13	  big	 low

	You could select a field a do some clustering of the records based
on the values in the field.  So, if I wanted to cluster on <name>, the
program would scan its values, and make 2 headers, "Foo" and "Bar".  This
would work great for popup lists, but you could relatively easily extend
it to other fields as well.

	The advantage of this approach is that it doesn't require
thinking about how the data will be displayed when you decide what should
be in each record.

	There is an experimental plugin interface in db, that I have been
looking at a bit lately.  It seems like it supports plugins for new list
views.  I think this would be a great plugin capability, I would
definately use it.

	-Scott

[pilot-db-list] Invalid file error

[John E. <jel...@ma...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greetings all.

DB is awesome.  I have used it quite a bit, and it is a welcome
relief to find a more powerful, more flexible, less costly db program
for the palm.

Ok.  So I have used it a bit, and tried developing my own DB pdb
file.
csv2pdb.exe works fine; itr processes the two attached file fine, no
errors output.

When I go to hotsync it, I get the following error:
 - Invalid handheld file deleted: C:\Palm\testpa\Install\eagles.pdb
(this was inspired by the Dallas schedule pdb!)

I can convert back with pdb2csv.exe with no errors reported (and the
files look fine).

Could anyone help me with this please?

System:
Win2K pro
Palm IIIc
Pilot-DB 0.3.2

Thanks, 

John Ellingsworth
Virtual Curriculum
Project Leader


-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBO+abxQbexkNIm1OFEQLR1wCgsuFxSyIhLdwso+GXZzSNqNgxTfoAmwbJ
62cR+hO7Vhl5BuZ/wM63ppdC
=VVG3
-----END PGP SIGNATURE-----

[pilot-db-list] Pilot-DB WebSite

[<hol...@di...>]

Hi,

This is just to inform everyone that
the Animated GIF in our WebSite'S 
start page has been updated to include
Sony's Clie, Handspring and HandEra
Handhelds.

Thanks,

Hans

Re:[pilot-db-list] HELP

[Chalain Marc<mar...@vo...>]

Which files did you download (please you the lastest uploaded the 4 november, yesterday)? In db-en.zip you have differents versions of DB:
 the smallest, the colored, the Handera support, the Sony support...
Use the one do you prefer.
The help-en.prc is a file you can add to the main prc file to have the help strings.

Salut,
Marc.


____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

Re:[pilot-db-list] record display/layout hints

[Chalain Marc<mar...@vo...>]

Do you read this mailing-list? Do you use the snapshot version?

You can create differents views in th ListView for a long time. You can display only few fields in the table and change the view with the right top list box.
Now with the snapshot version when you edit a View you can check a bow to "use this view to edit a record". Like that when you select a record in a view, DB display only the view fields of this record and you have a button on the rigth top to display all fields.

DB need a documentation!
Salut,
Marc.
____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] 0.3.3 beta 3

[Chalain Marc<mar...@vo...>]

i updated the snapshot.
New:
 * bug fix with the Float (An error on my platform).
 * bug fix on "Duplicate database".
 * Scroll arrow in the link choice box.
 * Global preferences to use or not the filters.

Salut,
Marc.
____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] record display/layout hints

[<pef...@fe...>]

Has anyone given any thought to putting "hints" in a database for
viewing records? AFAIK, records are currently displayed as a list of
fields going down the page, with each field consisting of a label and a
matching entry field. It would be nice to at the very least have
"headers" which would group items. For example, if I'm converting a
paper form that has a layout like this:

Foo
  Number  ___
  Size    ___
  Quality ___

Bar
  Number  ___
  Size    ___
  Quality ___

Then I end up converting it to a flat db format like this:

Foo Number  ___
Foo Size    ___
Foo Quality ___
Bar Number  ___
Bar Size    ___
Bar Quality ___

Now this makes sense; each record is unambiguous, and if I want to pull
the database into another program, I can "unflatten" it by pulling the
"Foo" and "Bar" off the front. However, it doesn't look very nice when
running the DB app. Specifically, the field names can get extremely
long and become confusing. I'd like to be able to have a database that
is flat, but with hints that tell it to display with some primitive
grouping.

I think this could be done with the following features:

 - implement a syntax for displaying field names; this could be as
   simple as hiding parts in brackets. So [Foo] Number would be
   displayed as "Number" on screen, but a DB-aware application would
   still unambiguously know it.

 - implement a field type of "null" or "label" which did not actually
   have a data item in each record, but would be displayed in the record
   table using only its name.

Using these features, a CSV metadata file might look like:

field "Foo" label
field "[Foo] Number" integer
field "[Foo] Size"   integer

etc.

It would also be possible to get away with only one of the features. If
you didn't have a syntax for displaying field names, then you could just
cut your field names down and group them contextually with labels.
However, you would probably end up with ambiguous names, which makes
"view" lines fail, and would make the database less robust when
exporting (I'm not even clear on whether the db format would support
ambiguous names at all).

If you didn't have labels, you could actually steal the information from
the bracketed field names. A simple algorithm would be to display a
heading for any field
 - that has a bracketed name
 - whose bracketed name is different than the last bracketed name

So:
field "[Foo] Number" integer
field "[Foo] Size" integer
field "[Bar] Number" integer
field "[Foo] Quality" integer

would be displayed as:

Foo
  Number ___
  Size   ___
Bar
  Number ___
Foo
  Quality ___

Anyway, I'm interested to see if this has been discussed before, if
there's another way to do what I want, if anybody has any comment on the
ideas, etc. If I don't get any negative feedback, I'm going to go ahead
and implement it, probably with bracketed names implying labels.

-Peff

[pilot-db-list] Re: update the plugins

[Chalain Marc<mar...@vo...>]

 * db-en.prc: the more simple version, no colors, no icons, no other database format support. Can load plugins.

 * db-en-color.prc: for PalmOS 3.5 and more device (colors and grayscale), with icons, no other database format. Can load plugins

 * db-en-handera.prc: like db-en-color.prc with Handera Higth Resolution support.

 * db-en-sony.prc like db-en-color.prc with Sony Higth Resolution support.

 * db-en-db2.prc: like db-en-color.prc but not need to load plugin to have the db2 format support.

 * db-en-mobiledb.prc: like db-en-color.prc but not need to load plugin to have the mobiledb format support.

 * db-en-jfile3.prc: like db-en-color.prc but not need to load plugin to have the jfile3 format support.

In plugins: the plugins that you can use with all versions of db which are in the file:
 * db2.prc: the db2 format support.

 * db-mobiledb.prc: the mobiledb format support.

 * db-jfile3.prc: the jfile3 format support.

But it's unuse to have the db2.prc plugin with the file db-en-db2.prc.

In the release version you will not have the db-en-db2.prc, db-en-mobiledb.prc, and db-en-jfile3.prc files. i builded them only to debug.

Salut,
Marc.
____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

Re:[pilot-db-list] Deletion of all records

[Chalain Marc<mar...@vo...>]

Perhaps, but now if you want delete all records but not the database, go in the chooser, in the database icon select "duplicate" menu entry, in the box give another name and select Extent: "Design Only"
Salut,
Marc.



> I've got a suggestion for a future revision: I have a database which 
> accumulates records and then at the end of a specified time 
> period, like the end of a month, I want to delete all the records.  
> The only way I've found to do this is to delete each record, one at a 
> time, which is a pain.  I don't want to delete the database, just the 
> contents.  I did do it by exporting to a comma delim file, wiping out 
> the contents of the comma delimited file, and importing the comma 
> delim file, but that was almost as tedious as deleting each record.  
> It would be nice if DB had an option to delete all records from a 
> given database.
> This is a terrific program, by the way!!!
> 
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Michael Reich
> mr...@cr...
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] Re: Deletion of all records

[<mr...@cr...>]

Klaus' method using a search would certainly meet my needs.  
Good approach.

On 1 Nov 2001, at 12:14, pilot-db-list-request@lists.s wrote:

> I would also say, that bulk deletions would be a nice feature.
> But i would like to suggest an other method. Base actions on
> a find. This way you could search for some kind of records
> and the search would mark all found records. Now one could base
> actions on this. This would require a limited wildcard find
> ( * represents all records ) to get the feature Michael Reich
> suggested. If you would implement a mark after find you could
> do other to me useful things. For example create and/or beam a
> new database with all found records, or copy all marked records
> to an other existing database. 
>  
> > This is a terrific program, by the way!!!
> 
> I must agree.
> 
> With kind regards
> 
> Klaus Leiss


======================
Michael Reich
mr...@cr...
======================

[pilot-db-list] Would a clie screenshot look like this?

[<aji...@t-...>]

Hi,

Would a clie screenshot look like this?

Attached is a clie gif into which I have
integrated a screen-shot.

I have no idea if this is what it would look
like due to the high resolution.

Can anyone confirm this?

Hans

[pilot-db-list] Do sony clie roms exist?

[<aji...@t-...>]

Hi,

In case anyone has noticed, I've added a few
Palm-Handhelds to the animated gif that appears
on the start page of pilot-db:

http://pilot-db.sourceforge.net/

Do sony clie roms (for pose 3.3) exist in principle?
Does anyone have one or know where to get one from?
Does anyone have any other exotic hardware-roms
on which Pilot-DB works?

Thanks

Hans

[pilot-db-list] Yet another Database

[<aji...@t-...>]

Hi!

I've just created and added a new database:

mime-types with programs and file-extensions.

If anyone is interested, please look though it
and let me know if there are any mistakes.

It can be found at the Web-Site:

http://pilot-db.sourceforge.net/

Hans

Re: [pilot-db-list] Bugs in db 0.3.3beta (28.Oct 2001)

[Tom D. <td...@us...>]

On Thursday 01 November 2001 08:50 am, Walter Koch wrote:

> I had had an error during changing database design, but it vanished after
> I deleted a DB "DBOStmp" (or similar). I suppose this DB is temporary
> created during the change of the design. Obviously my Palm had a fatal
> error once during database design change.

Yes. "DBOStmp" is the temporary database used during a rebuild.

[pilot-db-list] Bugs in db 0.3.3beta (28.Oct 2001)

[Walter K. <ko...@u3...>]

Moin,

some bugs I noticed in db 0.3.3beta (28.Oct 2001), english, no iconic on
Palm Vx, PalmOS 3.5.2 German:

Opening a database, that was just creating from existing database with
"duplicate" results in Fatal Exception. A repeated open works.=20

[1]No scroll indicators on the screen when entering or changing the
content of a link field. Hardware scroll buttons work fine.

Global Preferences, Buttons, Record scrolling. I choosed "line" for the
hardware buttons, but pressing them during editing a record results in a
switching to the next record.=20

[1]When using all Filter (Filter-1 to filter-4) an additional search
(without checking "add the filter" in the dialog) results in overwriting
=46ilter-1

I had had an error during changing database design, but it vanished after
I deleted a DB "DBOStmp" (or similar). I suppose this DB is temporary
created during the change of the design. Obviously my Palm had a fatal
error once during database design change.=20

Suggestion:
Lookupfunction (similar to adressbook) for the last sorted coloumn. I've
got a db with 8000 entries (a dictionary) and filtering is slow on that.=20

Thanks for all your work.

Gruss,
  Walter

[1] This bug already exists in db 0.3.3alphac (13.Oct 2001)
--=20
  Hochdahl am Neandertal

[pilot-db-list] Latest HandEra version

[Nicholas P. <ni...@ni...>]

I'm a bit confused about all the versions going around. I hacked in
full-screen support for the HE on a personal copy, but then Marc sent
me a version he was working on. Since then I've not really used DB
much, but was about to restart today so I'm trying to upgrade first.

I snagged a DB 0.3.3betac 31/Oct from this mailing list, but it
doesn't seem to have the HE support (no small fonts, no rotation, no
full screen).

I understand the CVS is well out of date ?

Is the CVS going to be updated ? That way I also have a platform on
which to try out my own code ideas :-)

Can someone point me in the direction of the "proper" latest
stable-ish version with HandEra/Sony features ?

Cheers,

 Nick

-- 
Part 3 MEng Cybernetics; Reading, UK       http://www.nickpiper.co.uk/
Change PGP actions of mailer or fetch key see website   1024D/3ED8B27F
Choose life. Be Vegan :-) Please reduce needless cruelty + suffering !

RE: [pilot-db-list] Deletion of all records

[Leiss, Klaus-G. 3. PPE-E. <Kla...@de...>]

Hello,

Michael Reich wrote
> It would be nice if DB had an option to delete all records from a 
> given database.

I would also say, that bulk deletions would be a nice feature.
But i would like to suggest an other method. Base actions on
a find. This way you could search for some kind of records
and the search would mark all found records. Now one could base
actions on this. This would require a limited wildcard find
( * represents all records ) to get the feature Michael Reich
suggested. If you would implement a mark after find you could
do other to me useful things. For example create and/or beam a
new database with all found records, or copy all marked records
to an other existing database. 
 
> This is a terrific program, by the way!!!

I must agree.

With kind regards

Klaus Leiss

Re: [pilot-db-list] Deletion of all records

[Tom D. <td...@us...>]

On Thursday 01 November 2001 12:04 am, mr...@cr... wrote:

> I've got a suggestion for a future revision: I have a database which
> accumulates records and then at the end of a specified time
> period, like the end of a month, I want to delete all the records.
> The only way I've found to do this is to delete each record, one at a
> time, which is a pain.  I don't want to delete the database, just the
> contents.  I did do it by exporting to a comma delim file, wiping out
> the contents of the comma delimited file, and importing the comma
> delim file, but that was almost as tedious as deleting each record.
> It would be nice if DB had an option to delete all records from a
> given database.

You could use the duplicate option with "Extent" set to "Design Only". Then 
delete the old database and use the new one.

[pilot-db-list] Deletion of all records

[<mr...@cr...>]

I've got a suggestion for a future revision: I have a database which 
accumulates records and then at the end of a specified time 
period, like the end of a month, I want to delete all the records.  
The only way I've found to do this is to delete each record, one at a 
time, which is a pain.  I don't want to delete the database, just the 
contents.  I did do it by exporting to a comma delim file, wiping out 
the contents of the comma delimited file, and importing the comma 
delim file, but that was almost as tedious as deleting each record.  
It would be nice if DB had an option to delete all records from a 
given database.
This is a terrific program, by the way!!!

======================
Michael Reich
mr...@cr...
======================

[pilot-db-list] outstanding piece of software!

[<aji...@t-...>]

Oliver wrote:

>I think all of the developers are doing a 
>wonderful job with this outstanding piece 
>of software, thank you very much for that!

I'll sign that!

Hans

Re: [pilot-db-list] Re: AW: AW: update crashes

[Tom D. <td...@us...>]

On Wednesday 31 October 2001 04:17 pm, Scott Wallace wrote:

> Hans, I maybe this bug is just in the mobiledb part?  I don't know.  I am
> sending you my latest build, including my most recent merges with marc's
> code.  It is somewhere past both of the versions you are using.  It
> doesn't seem to crash on your test case, but it is does not have plugins.
>
> (Note that calculated fields from old databases might not work!,
>   create a /new/ test database. )

We should start using the CVS repository for all these versions. It will make 
development much easier. Note that Marc did put one of the alphas into CVS 
put it doesn't have the recent stuff.

Re: [pilot-db-list] Re: AW: AW: update crashes

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

I'm a big fan of this idea  :)
emailing source code is getting out of control.
and merging is much easier with a bit of help from cvs.

	-Scott

> We should start using the CVS repository for all these versions. It will make
> development much easier. Note that Marc did put one of the alphas into CVS
> put it doesn't have the recent stuff.
>

-- 

[pilot-db-list] Re: AW: AW: update crashes

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

Hans, I maybe this bug is just in the mobiledb part?  I don't know.  I am
sending you my latest build, including my most recent merges with marc's
code.  It is somewhere past both of the versions you are using.  It
doesn't seem to crash on your test case, but it is does not have plugins.

(Note that calculated fields from old databases might not work!,
  create a /new/ test database. )

-Scott




> Dear Scott,
>
> I just tried creating a new database with the
> *NEW* db-en-mobiledb.prc
> I called the first field (float) fl1,
> the second (float)fl2 and the third
> (calculated) sum
>
> I entered the foll. values
>
> fl1 =3D 1.23456789
> fl2 =3D 5.67890123
>
> I tried to save the database and it crashed.
>
> Thanks,
>
> Hans
>
>
> -----Urspr=FCngliche Nachricht-----
> Von: Scott Wallace [mailto:swa...@my...]
> Gesendet: Mittwoch, 31. Oktober 2001 21:52
> An: Hans Ajiet Holtkamp
> Betreff: Re: AW: update crashes
>
>
>
> Ok,
> 	I didn't realize that you tried that latest version as well.. ;)
> Marc made lots of changes between the two versions we're talking about,
> so I'm not so sure he'll want to go back.  Anyway, I am thinking it mig=
ht
> be a good idea to use sourceforge for source control.  Have you guys tr=
ied
> that before?  Emailing source around gets confusing  ;)
>
> 	-Scott
>
>
> > Dear Scott,
> >
> > >the version you sent in your mail has now been integrated with marc'=
s
> most
> > >recent changes.  Script support is continuing to improve.
> >
> > I think there is a misunderstanding here...
> >
> > I had *NO* problems with the version I mailed (i.e. the version you
> > mailed to me).
> >
> > The versions I tried and which crashed WERE marc's
> > most recent versions- the version he sent today -
> >
> > Or do you mean another not-yet-released version?
> >
> > Hans
> >
>
> --
>

--=20

[pilot-db-list] update crashes (with script)

[<aji...@t-...>]

I forgot to tell you the script I used:
(+ %0 %1)

Dear Scott,

I just tried creating a new database with the
*NEW* db-en-mobiledb.prc
I called the first field (float) fl1,
the second (float)fl2 and the third
(calculated) sum  -  Script used (+ %0 %1)

I entered the foll. values

fl1 = 1.23456789
fl2 = 5.67890123


I tried to save the database and it crashed.

Thanks,

Hans


-----Ursprüngliche Nachricht-----
Von: Scott Wallace [mailto:swa...@my...]
Gesendet: Mittwoch, 31. Oktober 2001 21:52
An: Hans Ajiet Holtkamp
Betreff: Re: AW: update crashes



Ok,
	I didn't realize that you tried that latest version as well.. ;)
Marc made lots of changes between the two versions we're talking about,
so I'm not so sure he'll want to go back.  Anyway, I am thinking it might
be a good idea to use sourceforge for source control.  Have you guys tried
that before?  Emailing source around gets confusing  ;)

	-Scott


> Dear Scott,
>
> >the version you sent in your mail has now been integrated with marc's
most
> >recent changes.  Script support is continuing to improve.
>
> I think there is a misunderstanding here...
>
> I had *NO* problems with the version I mailed (i.e. the version you
> mailed to me).
>
> The versions I tried and which crashed WERE marc's
> most recent versions- the version he sent today -
>
> Or do you mean another not-yet-released version?
>
> Hans
>

--

[pilot-db-list] HELP

[Seth G. <set...@ya...>]

Hey,
I was able to successfully get the Palm DB on my Palm Pilot but the Palm DB
tools are giving me trouble. The files I downloaded do not install anything.
I went to the manual page and it offered little help. Can anyone explain
what I am doing wrong?
Thanks
Seth

Seth Goldsmith, Youth Team Leader
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.286 / Virus Database: 152 - Release Date: 10/9/2001

----------------------------------------------------
Sign Up for NetZero Platinum Today
Only $9.95 per month!
http://my.netzero.net/s/signup?r=platinum&refcd=PT97