Menu
▾
▴
pilot-db-list
You can subscribe to this list here.
| 1999 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(23) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2000 |
Jan
(15) |
Feb
(11) |
Mar
(6) |
Apr
(47) |
May
(14) |
Jun
(13) |
Jul
(20) |
Aug
(4) |
Sep
(15) |
Oct
(28) |
Nov
(40) |
Dec
(11) |
| 2001 |
Jan
(28) |
Feb
(9) |
Mar
(17) |
Apr
(10) |
May
(26) |
Jun
(31) |
Jul
(83) |
Aug
(66) |
Sep
(106) |
Oct
(82) |
Nov
(139) |
Dec
(76) |
| 2002 |
Jan
(138) |
Feb
(140) |
Mar
(118) |
Apr
(179) |
May
(85) |
Jun
(92) |
Jul
(53) |
Aug
(39) |
Sep
(60) |
Oct
(48) |
Nov
(114) |
Dec
(71) |
| 2003 |
Jan
(76) |
Feb
(58) |
Mar
(83) |
Apr
(70) |
May
(23) |
Jun
(63) |
Jul
(27) |
Aug
(233) |
Sep
(74) |
Oct
(35) |
Nov
(24) |
Dec
(42) |
| 2004 |
Jan
(85) |
Feb
(99) |
Mar
(33) |
Apr
(43) |
May
(17) |
Jun
(29) |
Jul
(17) |
Aug
(16) |
Sep
(17) |
Oct
(5) |
Nov
(3) |
Dec
(15) |
| 2005 |
Jan
(38) |
Feb
(24) |
Mar
(11) |
Apr
(14) |
May
(4) |
Jun
(15) |
Jul
(11) |
Aug
(5) |
Sep
(3) |
Oct
(14) |
Nov
(9) |
Dec
(3) |
| 2006 |
Jan
(9) |
Feb
(4) |
Mar
(4) |
Apr
(2) |
May
(6) |
Jun
(1) |
Jul
(3) |
Aug
(10) |
Sep
|
Oct
(1) |
Nov
|
Dec
(7) |
| 2007 |
Jan
(1) |
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
(3) |
Oct
|
Nov
(2) |
Dec
|
| 2008 |
Jan
(1) |
Feb
|
Mar
(2) |
Apr
(2) |
May
|
Jun
(3) |
Jul
|
Aug
(4) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2009 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Michael G. <ma...@th...> - 2002-11-06 20:47:53
|
> > There seem to be a limit of 32 items for list fields. Is
> > this hard-coded anywhere? Can it be changed?
>
> No, it's impossible (if i remember well the code). You should
> use the link field to extend the choice.
Ah, that's exactly what I was looking for! Thanks!
It seems that links also allow you to grow the menu over time. If you
link to an 'id' field in the menu database, you can add items to the
menu later (and you change their order). For instance in a "Paint"
database that needs an extensible list of colours:
Paint Database:
Field Type
----- ----
Paint Name String
Colour_id Link to Colour.id
Colour_Name Linked to Paint.Colour_id->Colour.id->Colour.name
Colour Database:
id name
-- ----
1 Red
2 Green
3 Blue
This works really well. And now you can change your colour table as
often as you like:
Colour Database:
id name
-- ----
1 Red
4 Orange
5 Yellow
2 Green
3 Blue
6 Indigo
7 Violet
Even though the order of the items has changed, the data in the Paint
database is still valid!
However, I would suggest a small UI enhancement. With the above method,
the user enters records by Tapping on the "Colour_id" field. This
brings up a dialog of the colour database with all of its fields
displayed in wide columns. Would it be possible to do the following:
* Tap on the linked field (Colour_Name) and get the same dialog?
* Tap on Colour_Name and see only a list of the values in
Colour.name?
* Allow 'linked' values to be associated with a view in the foreign
database? And then display that view when picking the value using
the linked field?
Just a thought!
Finally, a small bug. When editing a record in the Paint database,
above, DB can't seem to tell that a record has or has not been modified.
It always offers to save the record, even if there have been no changes.
This is with the Beta 1.1 Oct 14 Snapshot.
Michael
--
Michael Graham
ma...@th...
|
|
From: <aji...@t-...> - 2002-11-06 17:46:46
|
Hi all, This is just to inform everyone that the documentation of Pilot-DB 1.0.3 is now available online. Thanks, Hans |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-06 16:49:55
|
> Hello world, > > this is to announce, that a german version of the Pilot-DB > docs is on it's way. > > The first draft is beeing proofread and I finally managed > to put together enough libs, dlls, and stuff > to produce one HTML file from the source format. Great, perhaps you could become the doc builder? :) > > Some error messages still wait for investigation but the > conversion seems to have succeeded. > > One minor glitch though: > I recognized that the screen captures in the figures > directory are taken from a french GUI. > > I would like to replace them by german ones. > > Marc,Albert: How did you capture them? Emulators? I did the captures with the emulator. What do you need? > > I myself didn't mess around with emulators up to now, > just used the 'real stuff' so any hints would be welcome. > > There are some corrections allready so don't bother > with the first draft. I'll send in corected XML and > HTML versions 'real soon now'. ;-) > > See you, > Uwe Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: <Uwe...@t-...> - 2002-11-06 15:21:57
|
Hello world, this is to announce, that a german version of the Pilot-DB docs is on it's way.=20 The first draft is beeing proofread and I finally managed=20 to put together enough libs, dlls, and stuff to produce one HTML file from the source format. Some error messages still wait for investigation but the conversion seems to have succeeded. One minor glitch though: I recognized that the screen captures in the figures directory are taken from a french GUI. I would like to replace them by german ones. Marc,Albert: How did you capture them? Emulators? I myself didn't mess around with emulators up to now, just used the 'real stuff' so any hints would be welcome. There are some corrections allready so don't bother with the first draft. I'll send in corected XML and=20 HTML versions 'real soon now'. ;-) See you, Uwe=20 |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-06 13:09:45
|
> > There seem to be a limit of 32 items for list fields. Is this hard-coded > anywhere? Can it be changed? No, it's impossible (if i remember well the code). You should use the link field to extend the choice. > > I tried working around this by splitting my big list into two smaller > lists. This actually works pretty well. For the view, I created a > calculated field which displays the value of whichever menu has > an item selected. Here's the script: > > (? (seq %1 'N/A') %2 %1) > > Or a slightly cleaner version which leaves the field blank when nothing > in either menu is selected: > > (? (seq %1 'N/A') > (? (seq %2 'N/A') > '' > %2 > ) > %1 > ) > > This works nicely. > > Unfortunately, I'm having trouble changing my database to incorporate > the changes. I'm getting Fatal Exceptions whenever I add or modify > fields (or when I duplicate the database). These happen both with 1.0.3 > and the Oct 14 snapshot. > > The crash dialog doesn't provide any info. What can I do to help > diagnose these crashes? A little more work for us :| We will see! > > I do know that one of the crashes I was having is from the palm-db-tools > converter - It doesn't respect the 32 list item limit: instead it just > adds all the list items to the pdb, and corrupts the db in the process. Yes, but a new version will come soon. > > Michael > > P.S. Pilot-DB is great! Big thanks to the developers! > > > -- > Michael Graham > ma...@th... Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-06 13:03:24
|
I will see but i'm not sure that it's possible. You can write a Feature Request. > Hi, > > I am not sure if this has been already discussed : is it possible to store category settings between installations of DB? When I upgrade to a new version of DB the categories settings for my databases are lost. Would it be possible to allow the user to retain this information in future releases ? > > thanks > > Elias Biris, > Cadence Design Systems Ltd, SOC Design Centre > 1 The Alba Campus TEL: +44 (0)1506595036 > Livingston, EH54 7HH, UK FAX: +44 (0)1506595959 > > > ------------------------------------------------------- > This sf.net email is sponsored by: See the NEW Palm > Tungsten T handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en > _______________________________________________ > Pilot-db-list mailing list > Pil...@li... > https://lists.sourceforge.net/lists/listinfo/pilot-db-list > Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-06 12:58:42
|
> I looked through the instruction manual and the menus and cannot figure out how to delete a database once it is created. > Before to open the database, in the screen a front of the database name, ou have an icon. Tape on it, and select delete. Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-06 12:52:08
|
Hi Ajiet, the problem is that the documentation come from a XML file. I will see what i can to do. > Hi Albert, > > Since there is no link to your e-mail, I thought > I'll try to get in touch through the mail-list. > > I have just integrated your documentation into > the web-site. Thanks for the great doc!! > > I have a small request for the future, though: > > Could you add the graphic back.gif (attached) > to a new 'Images' (note the capital I) directory > which is at the same level as the doc directory > and add a link to it in the html-files. > > Could you also add the mainstyle.css-file into > the main directory, ie one higher than the doc directory > and add a link to it as well? > > Dir Structure: > > (Main Dir) > mainstyle.css > (doc) > (en) > -index.html > -etc > (Images) > -back.gif > -etc > > This is also the structure of the web-site. > > Ive done that for the index.htm (also attached) > > Here the changed lines: > > <link href=3D"../../mainstyle.css" rel=3D"stylesheet" type=3D"text/css" > title=3D"formal"> > </head><body background=3D"../../Images/back.gif"> > > > Thanks, > > Hans > Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: Michael G. <ma...@th...> - 2002-11-06 11:46:49
|
There seem to be a limit of 32 items for list fields. Is this hard-coded
anywhere? Can it be changed?
I tried working around this by splitting my big list into two smaller
lists. This actually works pretty well. For the view, I created a
calculated field which displays the value of whichever menu has
an item selected. Here's the script:
(? (seq %1 'N/A') %2 %1)
Or a slightly cleaner version which leaves the field blank when nothing
in either menu is selected:
(? (seq %1 'N/A')
(? (seq %2 'N/A')
''
%2
)
%1
)
This works nicely.
Unfortunately, I'm having trouble changing my database to incorporate
the changes. I'm getting Fatal Exceptions whenever I add or modify
fields (or when I duplicate the database). These happen both with 1.0.3
and the Oct 14 snapshot.
The crash dialog doesn't provide any info. What can I do to help
diagnose these crashes?
I do know that one of the crashes I was having is from the palm-db-tools
converter - It doesn't respect the 32 list item limit: instead it just
adds all the list items to the pdb, and corrupts the db in the process.
Michael
P.S. Pilot-DB is great! Big thanks to the developers!
--
Michael Graham
ma...@th...
|
|
From: Elias B. <eb...@ca...> - 2002-11-06 09:29:43
|
Hi, I am not sure if this has been already discussed : is it possible to = store category settings between installations of DB? When I upgrade to a = new version of DB the categories settings for my databases are lost. = Would it be possible to allow the user to retain this information in = future releases ? thanks Elias Biris, =09 Cadence Design Systems Ltd, SOC Design Centre 1 The Alba Campus TEL: +44 (0)1506595036 Livingston, EH54 7HH, UK FAX: +44 (0)1506595959 |
|
From: Scott W. <swa...@my...> - 2002-11-05 19:58:23
|
On Tue, 5 Nov 2002, Rolfe, Christopher wrote: > I looked through the instruction manual and the menus and cannot figure > out how to delete a database once it is created. > > Can you please let me know. In the chooser (the screen listing the databases) tap on the icon. This displays a menu of options. One will delete the database. -Scott |
|
From: Rolfe, C. <Chr...@ca...> - 2002-11-05 19:38:05
|
I looked through the instruction manual and the menus and cannot figure = out how to delete a database once it is created. =20 Can you please let me know. =20 Thanks! =20 Christopher Rolfe |
|
From: Scott W. <swa...@my...> - 2002-11-05 19:26:10
|
On Tue, 5 Nov 2002, Rene Lesouef wrote: > Hello, > > A easy usefull tool. Thanks ;) > > I get MSG "BAD ARGUMENTS FOR OVERFLOW' when i try to enter long script > going on the second line. > For ex: (+ %1 %2 %3 %4 %5 %6 %7 %8 %9 %10 %11 %12) > Have you got any idea or bypass Yes. It looks like you've got too many arguments for the '+' operator. Currently arguments are limited to somewhere around 10 or so, this helps ensure that memory requirements remain reasonable. I believe this is documented in the script readme. Anway, the way around this is to either break up your script to use two fields (one as an intermediate calculation) or simply to rearrage your arguments so that the limited stack does not overflow. Some experimentation may be necessary, but I think this would work: (+ (+ %1 %2 %3 %4) (+ %5 %6 %7 %8) (+ %9 %10 %11 %12)) if it all fits in the limited text space that is ;) -Scott |
|
From: hermann g. <hgr...@gm...> - 2002-11-05 18:47:17
|
hi 2 all, hi uwe ;-) i'm a german native speaker, i know DB now for a little time (about=20 version 0.3.2) and so i think i can do a job as a reader of the docu.=20 mail it to me ... so long, ciao hermann -----Original Message----- From: Uwe Klo=DF [SMTP:Uwe...@t-...] Sent: Monday, November 04, 2002 6:29 PM To: pilot-db-list Subject: Help needed (was: Re:[pilot-db-list] Where is Marc) Hello, > Sorry, i ahve my job, the last version of pilot-db, the future > version of db-tools and the support, then some time i forget > some things. No problem, I just wondered because your first reply was quite fast and thereafter a big silence. ;-) > I receive your translation, but at this date i have not the > tools to wrapp the docbook file to html files or others formats. Is there an environment (tools/scripts/makefiles) available (for download) that can be used? > Some body can help us?? I would like to add the request, that someone, preferrably a native german speaker, proofread the thing. I'm not a professional doc writer and it's only the first draft! ;-) Anyone out there on this list who can spare half an hour on this? Greetings, Uwe ------------------------------------------------------- This SF.net email is sponsored by: ApacheCon, November 18-21 in Las Vegas (supported by COMDEX), the only Apache event to be fully supported by the ASF. http://www.apachecon.com _______________________________________________ Pilot-db-list mailing list Pil...@li... https://lists.sourceforge.net/lists/listinfo/pilot-db-list |
|
From: <aji...@t-...> - 2002-11-05 17:12:09
|
Hi Albert,
Since there is no link to your e-mail, I thought
I'll try to get in touch through the mail-list.
I have just integrated your documentation into
the web-site. Thanks for the great doc!!
I have a small request for the future, though:
Could you add the graphic back.gif (attached)
to a new 'Images' (note the capital I) directory
which is at the same level as the doc directory
and add a link to it in the html-files.
Could you also add the mainstyle.css-file into
the main directory, ie one higher than the doc directory
and add a link to it as well?
Dir Structure:
(Main Dir)
mainstyle.css
(doc)
(en)
-index.html
-etc
(Images)
-back.gif
-etc
This is also the structure of the web-site.
Ive done that for the index.htm (also attached)
Here the changed lines:
<link href="../../mainstyle.css" rel="stylesheet" type="text/css"
title="formal">
</head><body background="../../Images/back.gif">
Thanks,
Hans
|
|
From: Rene L. <rle...@fr...> - 2002-11-05 15:18:29
|
Hello, A easy usefull tool. I get MSG "BAD ARGUMENTS FOR OVERFLOW' when i try to enter long script going on the second line. For ex: (+ %1 %2 %3 %4 %5 %6 %7 %8 %9 %10 %11 %12) Have you got any idea or bypass Thanks. RGDS Ren=E9 LESOUEF mailto:rle...@fr... = |
|
From: Jeyson T. <je...@li...> - 2002-11-05 12:50:01
|
Ol=E1 pilot-db-list, What is the possibility that Pilot-DB could undersand SQL Queries in the future? Some Script tasks could by better used and Understanded by using SQL. That's an Idea! --=20 []s Jeyson Teixeira Linkway Internet Provider |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-05 11:32:24
|
The documentation is in the distribution in the doc/en directory. > Hi > > I would like to have a calculated value in a field, and it appears that I > have to enter a script. Where can I find some information on how to write > a script? Is there any documentation? > > Kind regards, > > Hugo > > > ------------------------------------------------------- > This sf.net email is sponsored by: See the NEW Palm > Tungsten T handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en > _______________________________________________ > Pilot-db-list mailing list > Pil...@li... > https://lists.sourceforge.net/lists/listinfo/pilot-db-list > Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-05 11:30:37
|
I didn't build for arm because the PalmOS 5 use a m68k emulator. A ARM build is only usefull to have a faster application. For the HiRes you must wait a little. > On 5 Nov 02, mar...@la... <mar...@la...> wrote: > > I tried Pilot-DB on the PalmOS 5 simulator. Pilot-DB seems to > > run well. I ported the Hight Resolution of PalmOS 5 on the > > Pilot-DB 1.1 version, and i will do the same for Pilot-DB 1.0 > > Did you build for the M68k, or the ARM? > > Also, where can I get a copy of a Pilot-DB prc which supports PalmOS 5 > hires? Does the snapshot do this? > > Thanks! > > -- > ;; Erik Arneson <er...@aa...> JD, Ashland Lodge No. 23 ;; > ;; GPG Key ID: 2048R/8B4CBC9C RAM, Siskiyou Chapter No. 21 ;; > ;; <http://erik.arneson.org/> <http://www.aarg.net/mason> ;; > > Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: <tr...@or...> - 2002-11-05 10:44:01
|
You can download the file db-1_0_3.zip from pilot-db download page. It co= ntains an HTML doc. Chapter 9 is about scripts.=0D=0A=0D=0AThomas=0D=0A=0D= =0A---------- Mail d'origine -----------=0D=0A=0D=0A De : pilot-db-li= st-...@li...=0D=0A A : pil...@li...urcef= orge.net=0D=0A Cc : =0D=0A Date : Tue, 5 Nov 2002 10:09:30 UT=0D=0A= Objet : [pilot-db-list] Calculated field=0D=0A=0D=0A > Hi=0D=0A> =0D=0A= > I would like to have a calculated value in a field, and it appears that= I=0D=0A> have to enter a script. Where can I find some information on ho= w to write=0D=0A> a script? Is there any documentation?=0D=0A> =0D=0A> Ki= nd regards,=0D=0A> =0D=0A> Hugo=0D=0A> =0D=0A> =0D=0A> ------------------= -------------------------------------=0D=0A> This sf.net email is sponsor= ed by: See the NEW Palm =0D=0A> Tungsten T handheld. Power & Color in a c= ompact size!=0D=0A> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm00= 01en=0D=0A> _______________________________________________=0D=0A> Pilot-= db-list mailing list=0D=0A> Pil...@li...=0D=0A> ht= tps://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A> |
|
From: Hugo R. <hug...@wo...> - 2002-11-05 10:09:37
|
Hi I would like to have a calculated value in a field, and it appears that I have to enter a script. Where can I find some information on how to write a script? Is there any documentation? Kind regards, Hugo |
|
From: Erik A. <er...@aa...> - 2002-11-05 07:48:39
|
On 5 Nov 02, mar...@la... <mar...@la...> wrote: > I tried Pilot-DB on the PalmOS 5 simulator. Pilot-DB seems to > run well. I ported the Hight Resolution of PalmOS 5 on the > Pilot-DB 1.1 version, and i will do the same for Pilot-DB 1.0 Did you build for the M68k, or the ARM? Also, where can I get a copy of a Pilot-DB prc which supports PalmOS 5 hires? Does the snapshot do this? Thanks! -- ;; Erik Arneson <er...@aa...> JD, Ashland Lodge No. 23 ;; ;; GPG Key ID: 2048R/8B4CBC9C RAM, Siskiyou Chapter No. 21 ;; ;; <http://erik.arneson.org/> <http://www.aarg.net/mason> ;; |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-11-05 07:45:30
|
I tried Pilot-DB on the PalmOS 5 simulator. Pilot-DB seems to run well. I ported the Hight Resolution of PalmOS 5 on the Pilot-DB 1.1 version, and i will do the same for Pilot-DB 1.0 > Howdy everybody, > > Are there any plans to port pilot-db to the ARM processor? I'd love to > see what it could do when taking advantage of the extra power. > > -- > ;; Erik Arneson <er...@aa...> AARG Net <http://www.aarg.net/> ;; > ;; GPG Key ID: 2048R/8B4CBC9C <http://erik.arneson.org/> ;; > ;; "Resistance to tyrants is obedience to God!" - Thomas Jefferson ;; > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: ApacheCon, November 18-21 in > Las Vegas (supported by COMDEX), the only Apache event to be > fully supported by the ASF. http://www.apachecon.com > _______________________________________________ > Pilot-db-list mailing list > Pil...@li... > https://lists.sourceforge.net/lists/listinfo/pilot-db-list > Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)" |
|
From: <aji...@t-...> - 2002-11-04 20:23:01
|
Did anyone notice that we have crossed the 100000 visits since august 2001? That is the result of a great program! Thanks to Marc and Scott and everyone else who is involved! Hans |
|
From: Erik A. <er...@aa...> - 2002-11-04 20:01:14
|
Howdy everybody, Are there any plans to port pilot-db to the ARM processor? I'd love to see what it could do when taking advantage of the extra power. -- ;; Erik Arneson <er...@aa...> AARG Net <http://www.aarg.net/> ;; ;; GPG Key ID: 2048R/8B4CBC9C <http://erik.arneson.org/> ;; ;; "Resistance to tyrants is obedience to God!" - Thomas Jefferson ;; |
240 messages has been excluded from this view by a project administrator.
