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: Scott W. <swa...@my...> - 2002-12-17 19:19:57
|
Thanks for going the extra mile with this and figuring out /exactly/ what made your results different than marc's. I've corrected this, but it didn't make it into the 1.1 Beta 1. It will be in the 1.1 Beta 2 as soon as I get some feed back on the Beta 1. -Scott > > Ahhh. I know now what I did. I did tap the correct arrow, but not > exactly like you described it: > > First I tapped on the "type" arrow on the right and selected "list" to > check whether the field really was type "list". Drop down list is empty, > yes. But I aborted and then selected the property arrow on the left side > and, here the drop down list is empty too although I aborted type > selection before. |
|
From: Thomas R. <tr...@or...> - 2002-12-17 08:12:52
|
Yes, -t is assigned to both Title and Type option but I beleive that it will be interpreted as "Title" since this option is before "Type" in the list. You could try to use the --type and --title options instead. Thomas William P Tracy wrote: > I'm trying to use the command line csv2pdb -t BBC bbc.csv bbc.pdb > How do you distinguish the difference between title and type? > > > -i FILE Read the info FILE for the metadata. > -b Set the backup bit. (Same as "option backup on" in info file.) > -e Use extended CSV mode. (Same as "extended on" in info file.) > -t TITLE Set database title to TITLE. (Same as "title TITLE" in info file.) > -f SPEC Add a field described by SPEC. > SPEC consists of the field name, field type, and optional > field width separated by commas. > -t TYPE Set the database format to TYPE where TYPE is one of the > strings described in the database format sections above. The > default is "DB". > |
|
From: Guido P. <gui...@gm...> - 2002-12-16 20:15:56
|
The following was sent to me via private mail as a reply to my various postings. My reply to this, I think, clears up the confusion I had about editing existing drop down lists. It might be of some interest for you, which is why I send it to the mailinglist. If it´s not, please ignore. > Guido Pinkernell wrote: > >> mar...@la... schrieb: >> >>>> There is not bug on this part. front of your list field (in >>>> the database designer) you have an arrow which drop down a >>>> list with "properties" entry. tape on it and you will see the >>>> box with your full list of entries. >>> >>> >> >> This exactly is not the case. I tip on the arrow and the list, full >> before, is now empty. > > > You didn't! > At least you didn't tap the *correct* arrow. > There are two of them. > > One completely on the left (left to the field *name*) and one in the middle > (left to the field *type*). > > You most likely tapped the one left to the field *type*. > Marc talks about the one left to the field *name*. Ahhh. I know now what I did. I did tap the correct arrow, but not exactly like you described it: First I tapped on the "type" arrow on the right and selected "list" to check whether the field really was type "list". Drop down list is empty, yes. But I aborted and then selected the property arrow on the left side and, here the drop down list is empty too although I aborted type selection before. Somehow I must have done this two or three times, every time checking whether the field "really" is a list and then finding my dropdown list in "properties" gone and empty. Maybe that´s some bug? Doesn´t matter anymore to me, but maybe there are some other people out there who behave like me and start asking. So you might want to know about this little story. Again, thanks for all your help and patience. Guido |
|
From: Guido P. <gui...@gm...> - 2002-12-16 19:01:15
|
Guido Pinkernell schrieb: > By the way, I´d rather use a field with a drop down list but pilot db > doesn´t allow adding new entries to the list without rewriting the list > and then re-editing all records. Is there hope that this will be changed > sometime? > I need to apologize. Editing a drop down list once it is created now works on my palm. This morning I tried several times with the results described in my former emails. Though I can´t tell the difference. Thanks Marc for your patience ;) Guido |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-16 18:52:58
|
read the ch07s02.html file in the documentation or=0D=0A=0D=0Ahttp://pilo= t-db.sourceforge.net/doc/en/ch07s02.html=0A=0AAcc=E9dez au courrier =E9le= ctronique de La Poste : www.laposte.net ; =0A3615 LAPOSTENET (0,13 =80/mn= ) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A |
|
From: Guido P. <gui...@gm...> - 2002-12-16 18:47:15
|
mar...@la... schrieb: >> >>mar...@la... schrieb: >> >> >>I >did< read the documentation, and, from my question about > > adding >new< > >>entries to an existing drop down list, I think it follows > > that I know > >>about creating a drop down list first hand. What I didn´t > > know, and what > >>I couldn´t find in the documentation is, that editing an > > existing drop > >>down list means to completely redefine the field. Maybe > > that´s an > >>intenional part of pilot db or maybe that´s a bug or maybe ... >> >>Thanks for your help! >> >>Guido >> > > > There is not bug on this part. front of your list field (in > the database designer) you have an arrow which drop down a > list with "properties" entry. tape on it and you will see the > box with your full list of entries. This exactly is not the case. I tip on the arrow and the list, full before, is now empty. The same with a default value of a text field. Scott says to wait for version 1.1beta. I´ll do that and check whether both problems disappear. In the mailinglists archive there´s an entry (oct.2002) which reports the same default value problem. Thanks! Guido |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-16 18:27:40
|
> =0D=0A> =0D=0A> mar...@la... schrieb:=0D=0A> =0D=0A> >>=0D= =0A> >>By the way, I=B4d rather use a field with a drop down list but=0D= =0A> >=0D=0A> > pilot db=0D=0A> >=0D=0A> >>doesn=B4t allow adding new= entries to the list without=0D=0A> >=0D=0A> > rewriting the list=0D=0A= > >=0D=0A> >>and then re-editing all records. Is there hope that this=0D= =0A> >=0D=0A> > will be changed=0D=0A> >=0D=0A> >>sometime?=0D=0A> >= =0D=0A> >=0D=0A> > like a lot of body you didn't read the documentation= . The=0D=0Alist=0D=0A> > are inside the field properties.=0D=0A> =0D=0A>= I >did< read the documentation, and, from my question about=0D=0Aadding = >new< =0D=0A> entries to an existing drop down list, I think it follows=0D= =0Athat I know =0D=0A> about creating a drop down list first hand. What I= didn=B4t=0D=0Aknow, and what =0D=0A> I couldn=B4t find in the documentat= ion is, that editing an=0D=0Aexisting drop =0D=0A> down list means to com= pletely redefine the field. Maybe=0D=0Athat=B4s an =0D=0A> intenional par= t of pilot db or maybe that=B4s a bug or maybe ...=0D=0A> =0D=0A> Thanks = for your help!=0D=0A> =0D=0A> Guido=0D=0A> =0D=0A=0D=0AThere is not bug o= n this part. front of your list field (in=0D=0Athe database designer) you= have an arrow which drop down a=0D=0Alist with "properties" entry. tape = on it and you will see the=0D=0Abox with your full list of entries.=0D=0A= =0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net = ; =0A3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"= =0A=0A |
|
From: Guido P. <gui...@gm...> - 2002-12-16 18:16:22
|
mar...@la... schrieb: >> >>By the way, I´d rather use a field with a drop down list but > > pilot db > >>doesn´t allow adding new entries to the list without > > rewriting the list > >>and then re-editing all records. Is there hope that this > > will be changed > >>sometime? > > > like a lot of body you didn't read the documentation. The list > are inside the field properties. I >did< read the documentation, and, from my question about adding >new< entries to an existing drop down list, I think it follows that I know about creating a drop down list first hand. What I didn´t know, and what I couldn´t find in the documentation is, that editing an existing drop down list means to completely redefine the field. Maybe that´s an intenional part of pilot db or maybe that´s a bug or maybe ... Thanks for your help! Guido |
|
From: <fo...@cl...> - 2002-12-16 17:22:26
|
bonjour quel est le logiciel a installer sur mon pc pour sauvegarder ma base de = donn=E9es pilot-DB=20 MERCI =20 |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-16 17:22:17
|
> The default value for a text field, once defined, does not=0D=0Aappear = in the=0D=0A> databases records, both old and new. In fact it disappeared= =0D=0Afrom the=0D=0A> default value entry window as if it never got saved= .=0D=0A> =0D=0A> Thanks for your help on this.=0D=0A> =0D=0A> By the way,= I=B4d rather use a field with a drop down list but=0D=0Apilot db=0D=0A> = doesn=B4t allow adding new entries to the list without=0D=0Arewriting the= list=0D=0A> and then re-editing all records. Is there hope that this=0D=0A= will be changed=0D=0A> sometime?=0D=0A=0D=0Alike a lot of body you didn't= read the documentation. The list=0D=0Aare inside the field properties.=0D= =0A=0D=0A> =0D=0A> Guido=0D=0A> =0D=0A> =0D=0A=0A=0AAcc=E9dez au courrier= =E9lectronique de La Poste : www.laposte.net ; =0A3615 LAPOSTENET (0,13 = =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A |
|
From: Guido P. <gui...@gm...> - 2002-12-16 16:58:04
|
The default value for a text field, once defined, does not appear in the databases records, both old and new. In fact it disappeared from the default value entry window as if it never got saved. Thanks for your help on this. By the way, I´d rather use a field with a drop down list but pilot db doesn´t allow adding new entries to the list without rewriting the list and then re-editing all records. Is there hope that this will be changed sometime? Guido |
|
From: William P T. <wp...@at...> - 2002-12-16 16:33:07
|
I'm trying to use the command line csv2pdb -t BBC bbc.csv bbc.pdb How do you distinguish the difference between title and type? -i FILE Read the info FILE for the metadata. -b Set the backup bit. (Same as "option backup on" in info file.) -e Use extended CSV mode. (Same as "extended on" in info file.) -t TITLE Set database title to TITLE. (Same as "title TITLE" in info = file.) -f SPEC Add a field described by SPEC. SPEC consists of the field name, field type, and optional field width separated by commas. -t TYPE Set the database format to TYPE where TYPE is one of the strings described in the database format sections above. The default is "DB". |
|
From: Scott W. <swa...@my...> - 2002-12-16 15:29:27
|
Hmm. The code looks ok to me, and works on my emulator. Are you sure that the date is set correctly on your palm? Use the 'preferences' system application that comes with the device to make sure. -Scott On Mon, 16 Dec 2002, Roy, Jean-Bernard wrote: > Hello, > > Using the 'gcd' function in a script with db 1.0.3 gives me a wrong date. > For example, today my system date is 16/12/02, gcd gives me 16/12/98. > For information, I'm using a m515. > Any idea about this pb ? > Thanks. > -- |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-16 12:20:28
|
I will see that.=0D=0A=0D=0A> Hello,=0D=0A> =0D=0A> Using the 'gcd' funct= ion in a script with db 1.0.3 gives me=0D=0Aa wrong date.=0D=0A> For exam= ple, today my system date is 16/12/02, gcd gives me=0D=0A16/12/98.=0D=0A>= For information, I'm using a m515.=0D=0A> Any idea about this pb ?=0D=0A= > Thanks.=0D=0A> =0A=0AAcc=E9dez au courrier =E9lectronique de La Poste := www.laposte.net ; =0A3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13= 50 (0,34=80/mn)"=0A=0A |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-16 11:24:27
|
I translate this mail with my poor english:=0D=0AF. Battestini wrote:=0D=0A= =0D=0Ai used your software in professional environment, to keep on=0D=0Am= y "old" PalmIIIxe, data of management from a Ms/SQL Server,=0D=0Ausing th= e 'csv2pdb' tool: i was able to automatize (with=0D=0Avbscript) the updat= e of 5 databases on the Palm and the=0D=0Asending by mail. This 5 databas= es use links whichmake the=0D=0Anavigation useerfriendly: AND IT'S WORK != =0D=0A=0D=0AYour product is really friendly and i will recommand it aroun= d=0D=0Ame, in a professional environment, because it "keep the road".=0D=0A= Bravo=0D=0A=0D=0A> j'ai utilis=E9 votre programme dans un cadre professio= nnel,=0D=0Apour r=E9cup=E9rer sur mon "vieux" Palm IIIxe, des donn=E9es d= e=0D=0Agestion issues d'une base Ms/Sql Server, en passant par le=0D=0Aco= nvertisseur 'csv2pdb' : j'ai ainsi pu automatiser (par=0D=0Avbscript) la = mise =E0 jour de 5 bases sur le Palm et leur envoi=0D=0Ar=E9gulier par Ma= il. Ces 5 bases utilisent des liens r=E9ciproques=0D=0Aqui facilitent la = navigation : ET CA MARCHE !=0D=0A> =0D=0A> Votre produit est vraiment tr=E8= s sympa et je le=0D=0Arecommanderais autour de moi, dans le cadre profess= ionnel, car=0D=0Ail "tient la route'.=0D=0A> Bravo=0D=0A> F. Battestini=0D= =0A> =0D=0A> =0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www= .laposte.net ; =0A3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 = (0,34=80/mn)"=0A=0A |
|
From: Roy, Jean-B. <Jea...@jt...> - 2002-12-16 08:07:13
|
Hello, Using the 'gcd' function in a script with db 1.0.3 gives me a wrong date. For example, today my system date is 16/12/02, gcd gives me 16/12/98. For information, I'm using a m515. Any idea about this pb ? Thanks. |
|
From: Albert de K. <ade...@ya...> - 2002-12-14 21:09:11
|
After finishing the initial work on the English version of the documentation, I promised Scott and Marc that I would create some sample databases using views and scripts. The following zip archive (dbBases.zip) contains two Pilot-DB databases: (1) chequebook.pdb, which allows you to maintain your chequebook with Pilot-DB (There is some sample data on there that you will have to delete.) and the other file, (2) expenses.pdb, which you can use to record expenses and mileage (or kilometres). For the distance field in that database to be useful, you will need to edit its script and replace the zero by the setting that your odometer has when you start to record your expenses. Albert ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca |
|
From: Famille B. <fba...@fr...> - 2002-12-13 20:30:21
|
j'ai utilis=E9 votre programme dans un cadre professionnel, pour = r=E9cup=E9rer sur mon "vieux" Palm IIIxe, des donn=E9es de gestion = issues d'une base Ms/Sql Server, en passant par le convertisseur = 'csv2pdb' : j'ai ainsi pu automatiser (par vbscript) la mise =E0 jour de = 5 bases sur le Palm et leur envoi r=E9gulier par Mail. Ces 5 bases = utilisent des liens r=E9ciproques qui facilitent la navigation : ET CA = MARCHE ! Votre produit est vraiment tr=E8s sympa et je le recommanderais autour = de moi, dans le cadre professionnel, car il "tient la route'. Bravo F. Battestini |
|
From: Justin F. <ju...@ne...> - 2002-12-13 20:07:35
|
Thank you for your email. I am currently taking a short break before Christmas so that I can re-energise and provide you with even better service. I will return to full availability again on Monday, the 23rd of December. If you would like to contact me regarding urgent business, please try calling my mobile phone number. Alternately I will respond to your email on my return. Merry Christmas, Justin Freeman Software Engineer phone: 0402027764 email: ju...@ne... http://www.netmonkey.biz Net Monkey Pty. Limited. Custom software for business ABN: 46 100 906 947 |
|
From: Dan D <mt...@ho...> - 2002-12-13 18:02:40
|
I am attaching a file that should be what you are looking for. I set it up as this Field 0 Date Date Field 1 Concept String Field 2 Exp/Inc Integer Field 3 Balance Calc Calc "(sort 0 1)(+ %2 (ffr 3 -1 0)) Thanks go to Scott for helping me out on this one. I had the same question earlier. Ciao Dan Enjoy >From: Pablo Rodriguez <ou...@gm...> >To: pil...@li... >Subject: [pilot-db-list] a calculated field >Date: Thu, 12 Dec 2002 22:59:11 +0100 > >Hi there, > > >I wanted to make an simple expense tracker database. Field 0 contains the >date, field 1 the concept, field 2 the amount, field 3 income/expense, and >field 4 contains the total. > >The field 4 contains a script that adds or subtract (according to field 3) >the field 2 to the value of field 4 of the previous record. How should the >script be written? (Sorry, after reading the documentation three times, I'm >afraid that it's beyond my mathematical capabilities.) > >By the way, how can I have that numbers with two decimals don't get >rounded? > >Thanks for your help, > > >Pablo > > > >------------------------------------------------------- >This sf.net email is sponsored by: >With Great Power, Comes Great Responsibility Learn to use your power at >OSDN's High Performance Computing Channel >http://hpc.devchannel.org/ >_______________________________________________ >Pilot-db-list mailing list >Pil...@li... >https://lists.sourceforge.net/lists/listinfo/pilot-db-list _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail |
|
From: Pablo R. <ou...@gm...> - 2002-12-12 21:56:58
|
Hi there, I wanted to make an simple expense tracker database. Field 0 contains the date, field 1 the concept, field 2 the amount, field 3 income/expense, and field 4 contains the total. The field 4 contains a script that adds or subtract (according to field 3) the field 2 to the value of field 4 of the previous record. How should the script be written? (Sorry, after reading the documentation three times, I'm afraid that it's beyond my mathematical capabilities.) By the way, how can I have that numbers with two decimals don't get rounded? Thanks for your help, Pablo |
|
From: Scott W. <swa...@my...> - 2002-12-12 20:28:12
|
DB 1.0.x functions listed in the manual: http://pilot-db.sourceforge.net/ The functions for the current snap shot are listed in the script doc: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/pilot-db/pilot-db/docs/scripts.txt?rev=1.1.1.1&content-type=text/vnd.viewcvs-markup > > > Beside the examples in the documentation, has anyone ever made a list of > functions that can be done in the calcultion field. I am just trying to do > a basic function (take field 3 of the previous record and add it to field 2 > of the current record). If anyone can help please let me know. > Ciao Dan > |
|
From: Dan D <mt...@ho...> - 2002-12-12 19:58:59
|
Beside the examples in the documentation, has anyone ever made a list of functions that can be done in the calcultion field. I am just trying to do a basic function (take field 3 of the previous record and add it to field 2 of the current record). If anyone can help please let me know. Ciao Dan _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail |
|
From: <Uwe...@t-...> - 2002-12-12 14:37:22
|
Roy, Jean-Bernard wrote:
> Dear all,
>
> Has somebody already succeeded in computing the difference from to
> date fields in order to calculate a time difference ? I always have a
> bad argument error message.
>
First:
You needto read the docs!
Well in fact I reread the docs an will enhance that part.
It's not too clear indeed.
But nevertheless it's mentioned there!
Read it!
Then:
The you need to convert the date to a number.
The you need to divide by 24 and 60 because the number represents minutes.
I.e.: (/ (- (int %1) (int %0)) 1440)
> Is it possible to use current date in scripts ?
>
This was answered by Mark already!
See you,
Uwe
|
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-12 13:50:53
|
> Dear all,=0D=0A> =0D=0A> Has somebody already succeeded in computing th= e difference=0D=0Afrom to date=0D=0A> fields in order to calculate a time= difference ? I always=0D=0Ahave a bad=0D=0A> argument error message.=0D=0A= > Is it possible to use current date in scripts ?=0D=0A=0D=0Ain db 1.0.3,= i added a new function:=0D=0Agcd (get current date)=0D=0A=0D=0A> Tha= nks for your help.=0D=0A> JB=0D=0A> =0A=0AAcc=E9dez au courrier =E9lectro= nique de La Poste : www.laposte.net ;=0A3615 LAPOSTENET (0,13 =80/mn) ; t= =E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A |
240 messages has been excluded from this view by a project administrator.
