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: <sho...@rc...> - 2005-08-18 19:01:55
|
Is it possible for today's day and time to be automatically entered in a new record? Laura |
From: Michael H. <mic...@ch...> - 2005-08-10 22:24:22
|
I don't have easy access to the source at the moment and hoped somebody would have a quick answer for this one. I've got a drop down list iwth a fair number of option and I don't seem to be able to add anymore. I assume this is some sort of compile time constant I should be able to change? mph |
From: Rich S. <ka...@ze...> - 2005-07-24 05:16:20
|
Hello, > I have a question regarding pilot-db, although first I must say thank > you both for this project. I really love it as it helps me so much on > a day to day basis! > > My question is, why can't I use the abc keyboard (in the lower left > hand corner of the write space) while I am editing a database variable > if it is of type Note? > > I've done quite a bit of programming so if you want to describe the > problem to me, perhaps I can help as I'd be willing to contribute. > I've never done anything on the palm, but as long as it is C/C++ (I'm > assuming) I could probably handle it once I got used to it. > > Let me know if you know why this might be and as I said, I'd be happy > to help out. > > Thanks again! > > Rich Schwab > ka...@ze... > (206) 934 6840 > > Freelance Computer Consultant and Teacher > Visit www.zencomps.com for Articles and info on The Art of Simplicity > in Technology > > > |
From: Kitara <ver...@pa...> - 2005-07-17 11:18:11
|
Hey PilotDB Guys! Tank you so much for developping such a power database program for free! = The App is really great and works perfect om my Sony Clie UX50 and even = takes advantage of the landscape Display! The database app in general is = just what i needed. First i was thinking to devellop it myself, a = database app, but then I came allong your program and it is great!. But = i do not want to seem a bit nonchalant, but may i ask a question to you? = It's about further devellopment. 1. How come, if you look at a record, the fields don't use the entire = landscape screen? they just end at the normal 160 x resolution, that's = too bad, looked at the source, but since it's uncommented, i haven't = been able to find it yet myself. 2. Will you ever include picture support, like you import a picture from = a memorycard into a record, or maybe a converter on PC, wich you have to = upload to PDA somehow? 3. Will you ever set an option to the fields wether they are displayed = in bold or normal? It's usefull to set the for example a Title field as = BOLD so it is clearly seen on the screen? i would like to do this all myself, but i'm still a low level (beginner = actually) palm programmer, so i'm still learning. That's why i ask you = guys. Can this be done what i ask by making a plugin for PilotDB? if so, = how? then i can contribute to such a creative and fantastic development = team as yours. Btw, I especially like the look of the app, just like a built in one, = without such ugly buttons as Handbase has got... don't match the UI at = all... no the regular app style is great!! You should also look at my treath on the forum where i reviewed your = PilotDB app, and also pointed at a few bugs! It's over here: = http://www.1src.com/forums/showthread.php?t=3D92092 Sincirly, Nick |
From: Dennis M. <dmc...@ny...> - 2005-07-14 03:39:21
|
Gack. I humbly apologize. I completely misread this, and thought I was reading the Plucker mailing list, for which the comment below is true. That's what I get for trying to answer email while arguing with a friend on the phone. I know of no equivalent product to Pilot-DB for the Pocket PC, and no plans to create one. We now return you to your regularly scheduled mailing list... ______ Dennis > -----Original Message----- > From: pil...@li... > [mailto:pil...@li...]On Behalf Of Dennis > McCunney > Sent: Wednesday, July 13, 2005 10:17 PM > To: 'Thomas Mayfield' > Cc: pil...@li... > Subject: RE: [pilot-db-list] Pocket PC > > > > -----Original Message----- > > From: pil...@li... > > [mailto:pil...@li...]On Behalf > Of Thomas > > Mayfield > > Sent: Wednesday, July 06, 2005 4:03 PM > > To: pil...@li... > > Subject: [pilot-db-list] Pocket PC > > > > I didn't find anything in the archives, so I thought I'd > pose it here. > > This tool is great, especially with the plugins to read other > > database formats. The question (easily inferred from the title) is: > > Are there any plans to port this software to PocketPC? Is there > > similar software already available that is also open source? > > Tehre are no plans to port Plucker itself. There *is* a > third-party effort > to create a viewer for Plucker documents for the Pocket PC. > It's free, open > source software called Vade Mecum. See > http://vade-mecum.sourceforge.net/ > > > --Thomas > ______ > Dennis > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the 'Do More With Dual!' > webinar happening > July 14 at 8am PDT/11am EDT. We invite you to explore the > latest in dual > core and dual graphics technology at this free one hour event > hosted by HP, > AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar > _______________________________________________ > Pilot-db-list mailing list > Pil...@li... > https://lists.sourceforge.net/lists/listinfo/pilot-db-list |
From: Dennis M. <dmc...@ny...> - 2005-07-14 02:17:23
|
> -----Original Message----- > From: pil...@li... > [mailto:pil...@li...]On Behalf Of Thomas > Mayfield > Sent: Wednesday, July 06, 2005 4:03 PM > To: pil...@li... > Subject: [pilot-db-list] Pocket PC > > I didn't find anything in the archives, so I thought I'd pose it here. > This tool is great, especially with the plugins to read other > database formats. The question (easily inferred from the title) is: > Are there any plans to port this software to PocketPC? Is there > similar software already available that is also open source? Tehre are no plans to port Plucker itself. There *is* a third-party effort to create a viewer for Plucker documents for the Pocket PC. It's free, open source software called Vade Mecum. See http://vade-mecum.sourceforge.net/ > --Thomas ______ Dennis |
From: Thomas M. <tgm...@gm...> - 2005-07-06 20:03:18
|
I didn't find anything in the archives, so I thought I'd pose it here. This tool is great, especially with the plugins to read other database formats. The question (easily inferred from the title) is: Are there any plans to port this software to PocketPC? Is there similar software already available that is also open source? --Thomas |
From: Larry W. V. <lv...@ca...> - 2005-07-06 17:14:39
|
Quoting Andreas Joebges: > I have problems converting the included csv file to pdb. I get the > following error: > > CSV2PDB.EXE: csv file:1: number of fields doesn't match csv file: nb > fields found 1 nb field requested 4 > > Has anyone got an ideas? Well, that error means that for some reason, the conversion program isn't recognizing the character you have specified as a field delimiter. The most common reason I've seen for that is that the character is being recognized by the command line shell as a delimiter, and not ever passed along to the command. -- Tcl - The glue of a new generation. <URL: http://wiki.tcl.tk/ > Larry W. Virden <mailto:lv...@ca...><URL: http://www.purl.org/NET/lvirden/ > Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -><- |
From: Josh J. <jos...@co...> - 2005-07-06 02:07:26
|
I apologize if I've missed the answer to this in a FAQ file somewhere - I did my best to find it! I've used PilotDB in the past, but haven't used it for a while because of a problem I kept having. Whenever my PDA crashed and I restored all the backed-up databases, they wouldn't work correctly. I believe I couldn't even open the databases themselves because they were "not found", even though seemingly the file for each DB and the master index file were backed up and then restored. Has this been a known bug in the past? Has it been fixed now? Or is there a workaround? Thanks! -- Josh |
From: Andreas J. <bag...@gm...> - 2005-07-05 21:10:13
|
Hi, this is not the solution. The documentation states that you can choose the separator (and I tried it out). I can not even retransform a csv database which I made from a PDB. I allway get the error. ky...@ky... wrote: > Maybe I'm just being stupid, but the file you posted here isn't a csv (comma > separated value) file. > > Instead, it seems to be separated by semicolons. If this is the case, I > suggest you open this "CSV" file up in notepad or your favorite text editor, > and do a seek & destroy operation with all semicolons to be replaced with > commas. > > Then, when you save the modified contents, name the file toonbook.csv or > something like that. Try and open it up in Excel or some other csv supported > spreadsheet program first, then try and run csv2pdb. |
From: <ky...@ky...> - 2005-07-05 19:47:39
|
Quoting Andreas Joebges: > > --__--__-- > > Message: 1 > Date: Sun, 03 Jul 2005 01:14:40 +0200 > From: Andreas Joebges <bag...@gm...> > To: pil...@li... > Subject: [pilot-db-list] problems with csv2pdb > > This is a multi-part message in MIME format. > --------------050506060505060501090606 > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > Content-Transfer-Encoding: 7bit > > Hi, > > I have problems converting the included csv file to pdb. I get the > following error: > > CSV2PDB.EXE: csv file:1: number of fields doesn't match csv file: nb > fields found 1 nb field requested 4 > > Has anyone got an ideas? > > Best regards > Andreas Joebges > Always nice to find somebody else interested in the bagpipes. Maybe I'm just being stupid, but the file you posted here isn't a csv (comma separated value) file. Instead, it seems to be separated by semicolons. If this is the case, I suggest you open this "CSV" file up in notepad or your favorite text editor, and do a seek & destroy operation with all semicolons to be replaced with commas. Then, when you save the modified contents, name the file toonbook.csv or something like that. Try and open it up in Excel or some other csv supported spreadsheet program first, then try and run csv2pdb. Good luck, and cheers aye. I'm always looking for my next bagpipe set on ebay. I'll probably make a move after I get back from vacation. Kyle |
From: C. B. <c.b...@gm...> - 2005-07-04 16:22:41
|
I updated Pilot-DB to version 1.1.3. Now the links (LinkMaster) between databases didn't work anymore. Any suggestions? C. Brendes |
From: Andreas J. <bag...@gm...> - 2005-07-02 23:15:59
|
Hi, I have problems converting the included csv file to pdb. I get the following error: CSV2PDB.EXE: csv file:1: number of fields doesn't match csv file: nb fields found 1 nb field requested 4 Has anyone got an ideas? Best regards Andreas Joebges |
From: Dan R. <ROL...@em...> - 2005-06-20 21:10:03
|
Hi, I have created my first database with Pilot-DB and love the program. My problem is that I need an expression to subtract a start time field from an ending time field. I have the time preference set to 24 hour time. I want the database to calculate how much time was spent on a project. thanks in advance for any help Daniel Roland Assistant to the Dean School of Library and Information Management Emporia State University Emporia, KS 66801 800-552-4770 620-341-5233 Fax http://slim.emporia.edu |
From: <di...@ta...> - 2005-06-14 06:19:27
|
On Mon, Jun 13, 2005 at 12:54:40PM -0500, Denise Meyer wrote: > All, > I have just loaded and compiled palm-db-tools on a UNIX server running > solaris 9. > > When I attempt to convert a pdb to csv I receive the following error. I > have tried several different pdb files. > > /usr/local/bin/pdb2csv ../data/test.pdb ../data/test.csv > > /export/sse/dmeyer/scripts/PDB/palm-db-tools/data/test.pdb: unable to > determine database type > > test.pdb is the palm db that I am trying to convert. Is it a pilot-db db? palm-db-tools isn't a general-purpose palm db tool, it's only for pilot-db. > > When I try to convert from csv to pdb I receive the following error: > /usr/local/bin/csv2pdb -i ./metafile ../data/text.csv ../data/test.pdb > /usr/local/bin/csv2pdb: at least one field must be specified > > Can you please help me to determine how correct this issue? Can you post your "./metafile"? Is it written for csv2pdb? -- Didi |
From: Denise M. <Den...@Su...> - 2005-06-13 17:59:11
|
All, I have just loaded and compiled palm-db-tools on a UNIX server running solaris 9. When I attempt to convert a pdb to csv I receive the following error. I have tried several different pdb files. /usr/local/bin/pdb2csv ../data/test.pdb ../data/test.csv /export/sse/dmeyer/scripts/PDB/palm-db-tools/data/test.pdb: unable to determine database type test.pdb is the palm db that I am trying to convert. When I try to convert from csv to pdb I receive the following error: /usr/local/bin/csv2pdb -i ./metafile ../data/text.csv ../data/test.pdb /usr/local/bin/csv2pdb: at least one field must be specified Can you please help me to determine how correct this issue? Thanks in advance for your help. -- Denise Meyer Sun Microsystems EDS Program Manager ______________________ 16000 N. Dallas Parkway, 7th Floor Dallas, Texas 75248 Office: 972-788-3175 or X43175 |
From: Jonathan F. <jo...@gm...> - 2005-06-07 10:31:01
|
On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote: > On Tue, Jun 07, 2005 at 10:52:45AM +0100, Jonathan Fitt wrote: > > On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote: > > > On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote: > > > > On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote: > > > > > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote: > > > > > > I have a new question though: > > > > > > Is it possible to get back into the calculated field definition= after > > > > > > setting it? The only way I can get back in is by changing the f= ield > > > > > > type to something else, and then back to calculated. However th= is > > > > > > deletes its contents. > > > > > > > > > > Simply choose again 'calculated'. That is, tap the already-select= ed > > > > > 'Calculated' option. > > > > > > > > I've tried that, it closes the selction box, but the script edit > > > > window does not appear. The only way I can get it to appear is to > > > > select another type e.g. string, and then select calculated again. > > > > > > Well, this might be a change from 1.1.0, which is the version I use. > > > Can you try and check? > > > > I'm running 1.1.3. I don't really want to go backwards as it is > > working at the moment. Could it be a device issue? I'm on an old Palm > > V. >=20 > I don't think it's the device. It used to work for me on a VX. >=20 > > > > > > > > > > > > > > > > > > Also, what do global scripts do, and what is an example use for= them? > > > > > > > > > > Look at docs/scripts.txt. IIRC the only use is to run one when se= lecting > > > > > a view - e.g. to automatically sort the rows when entering a spec= ific > > > > > view. > > > > > > > > The scripts section in the manual doesn't go into global scripts. I= s > > > > > > It's not in the user manual. Look at docs/scripts.txt. > > > > I'm probably missing something, but I have no docs/scripts.txt all the > > documentation is in html, and it's the same as the user manual online. >=20 > Sorry. Look at docs under the source directory. It's different from the > binary distribution. Ah, that's much better. It has a section on Global scripts, and the MathLib functions, and a statement on script length which has got me before. Thanks, Jon |
From: <di...@ta...> - 2005-06-07 10:17:37
|
On Tue, Jun 07, 2005 at 10:52:45AM +0100, Jonathan Fitt wrote: > On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote: > > On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote: > > > On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote: > > > > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote: > > > > > I have a new question though: > > > > > Is it possible to get back into the calculated field definition after > > > > > setting it? The only way I can get back in is by changing the field > > > > > type to something else, and then back to calculated. However this > > > > > deletes its contents. > > > > > > > > Simply choose again 'calculated'. That is, tap the already-selected > > > > 'Calculated' option. > > > > > > I've tried that, it closes the selction box, but the script edit > > > window does not appear. The only way I can get it to appear is to > > > select another type e.g. string, and then select calculated again. > > > > Well, this might be a change from 1.1.0, which is the version I use. > > Can you try and check? > > I'm running 1.1.3. I don't really want to go backwards as it is > working at the moment. Could it be a device issue? I'm on an old Palm > V. I don't think it's the device. It used to work for me on a VX. > > > > > > > > > > > > > > Also, what do global scripts do, and what is an example use for them? > > > > > > > > Look at docs/scripts.txt. IIRC the only use is to run one when selecting > > > > a view - e.g. to automatically sort the rows when entering a specific > > > > view. > > > > > > The scripts section in the manual doesn't go into global scripts. Is > > > > It's not in the user manual. Look at docs/scripts.txt. > > I'm probably missing something, but I have no docs/scripts.txt all the > documentation is in html, and it's the same as the user manual online. Sorry. Look at docs under the source directory. It's different from the binary distribution. -- Didi |
From: Jonathan F. <jo...@gm...> - 2005-06-07 09:52:52
|
On 6/7/05, Yedidyah Bar-David <di...@ta...> wrote: > On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote: > > On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote: > > > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote: > > > > I have a new question though: > > > > Is it possible to get back into the calculated field definition aft= er > > > > setting it? The only way I can get back in is by changing the field > > > > type to something else, and then back to calculated. However this > > > > deletes its contents. > > > > > > Simply choose again 'calculated'. That is, tap the already-selected > > > 'Calculated' option. > > > > I've tried that, it closes the selction box, but the script edit > > window does not appear. The only way I can get it to appear is to > > select another type e.g. string, and then select calculated again. >=20 > Well, this might be a change from 1.1.0, which is the version I use. > Can you try and check? I'm running 1.1.3. I don't really want to go backwards as it is working at the moment. Could it be a device issue? I'm on an old Palm V. =20 > > > > > > > > > > Also, what do global scripts do, and what is an example use for the= m? > > > > > > Look at docs/scripts.txt. IIRC the only use is to run one when select= ing > > > a view - e.g. to automatically sort the rows when entering a specific > > > view. > > > > The scripts section in the manual doesn't go into global scripts. Is >=20 > It's not in the user manual. Look at docs/scripts.txt. I'm probably missing something, but I have no docs/scripts.txt all the documentation is in html, and it's the same as the user manual online. =20 Jon |
From: <di...@ta...> - 2005-06-07 09:34:56
|
On Tue, Jun 07, 2005 at 09:30:07AM +0100, Jonathan Fitt wrote: > On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote: > > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote: > > > I have a new question though: > > > Is it possible to get back into the calculated field definition after > > > setting it? The only way I can get back in is by changing the field > > > type to something else, and then back to calculated. However this > > > deletes its contents. > > > > Simply choose again 'calculated'. That is, tap the already-selected > > 'Calculated' option. > > I've tried that, it closes the selction box, but the script edit > window does not appear. The only way I can get it to appear is to > select another type e.g. string, and then select calculated again. Well, this might be a change from 1.1.0, which is the version I use. Can you try and check? > > > > > > > Also, what do global scripts do, and what is an example use for them? > > > > Look at docs/scripts.txt. IIRC the only use is to run one when selecting > > a view - e.g. to automatically sort the rows when entering a specific > > view. > > The scripts section in the manual doesn't go into global scripts. Is It's not in the user manual. Look at docs/scripts.txt. > the only possible command the sort command? > I would have thought that a script used at that time would be used to > select records to view, and then sort them. So that you could find all > records containing the name Adam, and sort them by age, for example. It does have also a filter. -- Didi |
From: Jonathan F. <jo...@gm...> - 2005-06-07 08:30:46
|
On 6/4/05, Yedidyah Bar-David <di...@ta...> wrote: > On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote: > > I have a new question though: > > Is it possible to get back into the calculated field definition after > > setting it? The only way I can get back in is by changing the field > > type to something else, and then back to calculated. However this > > deletes its contents. >=20 > Simply choose again 'calculated'. That is, tap the already-selected > 'Calculated' option. I've tried that, it closes the selction box, but the script edit window does not appear. The only way I can get it to appear is to select another type e.g. string, and then select calculated again. =20 > > > > Also, what do global scripts do, and what is an example use for them? >=20 > Look at docs/scripts.txt. IIRC the only use is to run one when selecting > a view - e.g. to automatically sort the rows when entering a specific > view. The scripts section in the manual doesn't go into global scripts. Is the only possible command the sort command? I would have thought that a script used at that time would be used to select records to view, and then sort them. So that you could find all records containing the name Adam, and sort them by age, for example. Jon |
From: <di...@ta...> - 2005-06-04 10:52:36
|
On Fri, Jun 03, 2005 at 04:13:39PM +0100, Jonathan Fitt wrote: > I have a new question though: > Is it possible to get back into the calculated field definition after > setting it? The only way I can get back in is by changing the field > type to something else, and then back to calculated. However this > deletes its contents. Simply choose again 'calculated'. That is, tap the already-selected 'Calculated' option. > > Also, what do global scripts do, and what is an example use for them? Look at docs/scripts.txt. IIRC the only use is to run one when selecting a view - e.g. to automatically sort the rows when entering a specific view. -- Didi |
From: Jonathan F. <jo...@gm...> - 2005-06-03 15:13:44
|
On 6/2/05, Yedidyah Bar-David <di...@ta...> wrote: > On Thu, Jun 02, 2005 at 05:34:16PM +0100, Jonathan Fitt wrote: > > Thanks. Clearing up that malformed view sorted it. > > > > I have a more complicated question. > > I have a databse which contains archery rounds (the one I sent) and > > the number of dozen arrows each entails. I also have a database of my > > scores. One of the fields in the score database is a link to the > > rounds database so that I can select a round name. In my score > > database I have the number of hits. I want to take this and the number > > of dozen field from the corresponding record in the round database and > > work out my hit percentage as a calculated field. Is this possible? > > Basically in my record I want to read a field from another record > > linked to by a field in the record. >=20 > It's not possible, as far as I understand. I do not know how much work > it would take to make it possible - it might not be that much work. I've worked out how I would do it. I can make a linked field which points to the dozens field in the record the original link field points to. I can them have my percentage field take the value from the linked field, and the number of hits, and display a percentage. I have a new question though: Is it possible to get back into the calculated field definition after setting it? The only way I can get back in is by changing the field type to something else, and then back to calculated. However this deletes its contents. Also, what do global scripts do, and what is an example use for them? Thanks, Jonathan |
From: <di...@ta...> - 2005-06-02 21:07:45
|
On Thu, Jun 02, 2005 at 05:34:16PM +0100, Jonathan Fitt wrote: > Thanks. Clearing up that malformed view sorted it. > > I have a more complicated question. > I have a databse which contains archery rounds (the one I sent) and > the number of dozen arrows each entails. I also have a database of my > scores. One of the fields in the score database is a link to the > rounds database so that I can select a round name. In my score > database I have the number of hits. I want to take this and the number > of dozen field from the corresponding record in the round database and > work out my hit percentage as a calculated field. Is this possible? > Basically in my record I want to read a field from another record > linked to by a field in the record. It's not possible, as far as I understand. I do not know how much work it would take to make it possible - it might not be that much work. -- Didi |
From: Jonathan F. <jo...@gm...> - 2005-06-02 16:35:00
|
Thanks. Clearing up that malformed view sorted it. I have a more complicated question. I have a databse which contains archery rounds (the one I sent) and the number of dozen arrows each entails. I also have a database of my scores. One of the fields in the score database is a link to the rounds database so that I can select a round name. In my score database I have the number of hits. I want to take this and the number of dozen field from the corresponding record in the round database and work out my hit percentage as a calculated field. Is this possible? Basically in my record I want to read a field from another record linked to by a field in the record. Thanks again. On 6/2/05, Yedidyah Bar-David <di...@ta...> wrote: > On Thu, Jun 02, 2005 at 04:57:32PM +0100, Jonathan Fitt wrote: > > Hello all, > > > > I'm having problems with the attached PDB. I originally had it working > > without the last column. I recreated it using JPilot-DB from a csv > > where I had added the last column. Since then it has thrown a fatal > > error everytime I try and open it. I've tried recreating it afresh, > > reinstalling Pilot-DB, everything I can think of, but it keeps > > throwing the error. > > Any ideas? > > > > On a side note I've not had much luck editing schema and or records > > with JPilot-DB. It doesn't seem to accept changes, hence me recreating > > the db from a csv file. >=20 > I suggest you try using palm-db-tools. I tried pdb2csv on the db you > attached, and it worked well. It outputed an inf file with a line > view "newview" > which is invalid. I can't know what exactly was the reason - maybe > you did not define the view well or there is some other problem. If > I delete this line and csv2pdb, pilot-db can open the generated db. > -- > Didi >=20 > |