pilot-db-list Mailing List for DB (Page 16)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

I'm trying to do this about three fields:

( - %3 (+ %4 %5))

But I get this message: "Bad Arguments for -"

Please let me know what I'm doing bad.

1. I wanna avoid to have repeated records with the same filed ID, so I 
would like to know if there's anyway to implement "principal keys or 
indexes" in DB.
The incremental ID solution don't solve my problem, I need especific IDs 
for every record.

2. I don't wanna seem a dumb, but I have terrible problems to do this 
whith a script:

(- %1 ( + %2 %3))
Explication:
First: field%2 + field%3 = result1
Then: field%1 - result1 = final result

I get an error message.

Thank you in advance.

1. I wanna avoid to have repeated records with the same filed ID, so I
would like to know if there's anyway to implement "principal keys or
indexes" in DB.
The incremental ID solution don't solve my problem, I need especific IDs
for every record.

2. I don't wanna seem a dumb, but I have terrible problems to do this
whith a script:

(- %1 ( + %2 %3))
Explication:
First: field%2 + field%3 = result1
Then: field%1 - result1 = final result

I get an error message.

Thank you in advance.

I've just put up yet another alpha release to try: db-1.2.0-alpha4.prc
It has (what I hope is) at least one solid bug fix for "Boolean fields
fail to display" (917592), plus a few blind stabs at some other
problems for Tungsten users.

I've now got the PalmOS Simulators working reasonably well on Windows
and talking adequately to GDB on Linux, so as long as the remaining
Tungsten bugs are reproduceable on a simulator and not just a real
device I have good hope for being able to solve them reasonably
efficiently.

--nate

On Mon, 29 Mar 2004 17:44:13 -0500
bp...@tr... wrote:

> Hey guys,
> 
> Perhaps I don't understand how the .nfo files are suposed to work, but
> when building pdb's using the "calculated" field type, my script text 
> never seems to make it into the pdb file.

Hi,
as far as I know, the db-tools does not support calculated fields

Thomas

Hey guys,

Perhaps I don't understand how the .nfo files are suposed to work, but 
when building pdb's using the "calculated" field type, my script text 
never seems to make it into the pdb file.

Here is the nfo sample:

title "Cass, 013, XB, Canvass Walk"
csvfile "/export/var/palm/187/29.csv"
field "voter_id" integer
field "lname" string
field "fname" string
field "stnum" string
field "stname" string
field "maddress" string
field "city" string
field "stapt" string
field "phone" string
field "stsen02" string
field "partyid02" string
field "g2000" boolean
field "refused" string
field "issue2" list "/E/F/H/J/N/S/T"
field "state" list "MN/MT/ND/SD"
field "Q1" list "If the election were held today, which candiate would you vote fore?"
field "pres04" list "/0/AS/BG/CB/DG/DK/GB/HD/JE/JK/JL/U/WC"
field "date_mod" calculated "(gcd)"
field "time_mod" calculated "(gct)"
view "All Fields" "lname" 40 "fname" 30 "stnum" 30 "stname" 30 "maddress" 125 "city" 30 "stapt" 30 "phone" 30 "stsen02" 30 "partyid02" 30 "g2000" 15 "refused" 30 "issue2" 30 "state" 20 "pres04" 30
option backup off
option readonly off
extended on

The date_mod/time_mod fields come up as "n/a" in the database, and 
attempts to view the scrip show a series of bad characters.

Any ideas?

-- 
Brett Paden
bp...@tr...
http://trimeros.com
877.352.data (office)
954.663.0678 (cell)

Hi,
I would like to use Pilot-DB on my Palm T3.
With "large" pdb files, i have an Alert : "Experimental Very Large DataBase
Support.".
Can you please tell me if there is a way to remove this alert ?
Best Regards,
M.Anseaume.

I am endevering to write a plugin that will access an external device on 
demand from the user. My first, of many, question is can a plugin be 
activated by a pen stroke or ... ? Maybe someone could list the various 
ways a plugin can be invoked?

Thanks,
Ernie

Not the new contact informations.
db-AdrressDB.prc is a plugin to view o=
nly the standard contact
informations.

> 
> Hi,
> 
> I'm planning =
to install pilot-db. I would like to know if
there is the 
> possibilit=
y to use the data of the "contacts" applications 
of Palm 
> Tungsten E=
.
> 
> Thank you in advance.
> 
> 
> 
> ---------------------------=
----------------------------
> This SF.Net email is sponsored by: IBM Li=
nux Tutorials
> Free Linux tutorial presented by Daniel Robbins, Preside=
nt
and CEO of
> GenToo technologies. Learn everything from fundamentals=
 to
system
>
administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=
=3D3638&op=3Dclick
> _______________________________________________
> =
Pilot-db-list mailing list
> Pil...@li...
> http=
s://lists.sourceforge.net/lists/listinfo/pilot-db-list
> =0A=0AAcc=E9dez=
 au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3615 LAPOS=
TENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)=0A=0A

Hi,

I'm planning to install pilot-db. I would like to know if there is the 
possibility to use the data of the "contacts" applications  of Palm 
Tungsten E.

Thank you in advance.

I just put up another alpha release: db-1.2.0-alpha3.prc.  No real
code changes, but some significant configuration differences.  This
one is configured with --enable-handera and --enable-sony, which was
slightly trickier to accomplish than I had expected.  

(Did any see me getting flamed on the prc-tools-devel list for asking
why the Sony SDK's weren't working with prc-tools?)

I have some slight hope that do to the crossed nature of the #ifdef's
in the code, that one of these options might help with some of the
Tunsten issues.   I don't have access to a Tungsten, though, so I
haven't been able to test this, though.  Perhaps someone could?

Bugs: <http://sourceforge.net/tracker/?group_id=621&atid=100621>.

--nate

On Tue, Mar 23, 2004 at 07:19:46PM -0500, Kyle davis wrote:
> Methinks 1.20 alpha 2 doesn't play nicely with links.

What problems are you seeing.  Likely you are right, but the more
specific the bug report, the easier it is to fix.

(I just played with it a bit, and found that the list view always
seems to be out of date although the record view appears correct)

> Also, even though I deleted the DB app and then installed new alpha 2, the
> version still shows up as being 1.10.

True, I haven't changed the version yet.  I'll try to do so for the
next alpha release.

> Should I have totally uninstalled DB using the uninstall app and then
> install alpha 2 piecemeal?

Shouldn't matter, as far as i know.  Simply removing the old one and
dropping it in should do.  I'm not sure what happens if one doesn't
remove the old PRC...

--nate

Hey guys!

Methinks 1.20 alpha 2 doesn't play nicely with links.

Also, even though I deleted the DB app and then installed new alpha 2, the
version still shows up as being 1.10.

Should I have totally uninstalled DB using the uninstall app and then
install alpha 2 piecemeal?

Enquiring minds want to know.

Also, I have added a DB (mostly blank) that I've been playing around with at
the sourceforge site.  It requires AddressDB to be running as well.

Kyle 

-----Original Message-----
From: pil...@li...
[mailto:pil...@li...] On Behalf Of
pil...@li...
Sent: Thursday, March 18, 2004 11:10 PM
To: pil...@li...
Subject: Pilot-db-list digest, Vol 1 #868 - 1 msg

Send Pilot-db-list mailing list submissions to

	pil...@li...

To subscribe or unsubscribe via the World Wide Web, visit

	https://lists.sourceforge.net/lists/listinfo/pilot-db-list

or, via email, send a message with subject or body 'help' to

	pil...@li...

You can reach the person managing the list at

	pil...@li...

When replying, please edit your Subject line so it is more specific

than "Re: Contents of Pilot-db-list digest..."

Today's Topics:

   1. Re:new improved 1.2.0 alpha 2 released (marc.chalain)

--__--__--

Message: 1

Date: Wed, 17 Mar 2004 11:29:28 +0100

Subject: Re:[pilot-db-list] new improved 1.2.0 alpha 2 released

From: "marc\.chalain" <mar...@la...>

To: "nate" <na...@ve...>

Cc: "pilot-db-list" <pil...@li...>

>     - Fixed crash in Sort dialogue  (917583)

>     - Fixed last record=

 uneditable  (917146)

Very old bugs already fix in previous versions.=0D

=

Sorry.

=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.la=

poste.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,3=

4=80/mn)=0A=0A

--__--__--

_______________________________________________

Pilot-db-list mailing list

Pil...@li...

https://lists.sourceforge.net/lists/listinfo/pilot-db-list

End of Pilot-db-list Digest

Nate, I have compiled with the Sony SDKs.  Didn't go that great and 
didn't result in the VSK (virtual silk screen) being enabled, but that 
may be due to hardcoding of the width; I have a UX50 which postdates the 
latest code.

I'll take a look at that against the newest CVS this weekend.

     -TMcN-

Nathan Kurz wrote:

>I'm putting some time into the immediate goal of getting creating a
>new stable release candidate, but I'm not getting that far.  The main
>problem I'm hitting is that most of the outstanding bugs (or at least
>the ones reported on the bug tracker) are specific to Tungsten users,
>and I don't have a Tungsten to test on. 
>
>For older Palms, there is an Emulator that runs well on Linux.  For
>newer version (OS 5 and greater) there is a Simulator, but it's
>Windows only, and I due to a medical condition (acute rage syndrome)
>I'm not allowed to use Windows machines.  I just wasted a day trying
>to see if I could make the Simulator run under Wine.  It almost
>works---well enough that I can occasionally confirm a bug, but not
>well enough to actually use for debugging.  And it turns out that Wine
>is sufficiently close to Windows to have affected me (kill kill kill).
>
>My first guess is that the bugs aren't actually Tungsten related, but
>high-resolution related.  Perhaps because of the messed up nature of
>the code, one needs to compile with "CONFIG_HANDERA" or "CONFIG_SONY"
>to get the Tungsten to work properly.  But compiling with these
>requires some proprietary SDK's which I don't have yet, so I haven't
>tried that.  I'll try to get them later tonight.
>
>Anyway, if anyone wants to step up and help with the Tungsten bugs,
>that would be great.  And if anyone is good with making apps work with
>wine (DLL disassembly and the like) help would be appreciated.  
>
>--nate, hoping to fix the bugs so he can work on the new features
>
>
>
>
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: IBM Linux Tutorials
>Free Linux tutorial presented by Daniel Robbins, President and CEO of
>GenToo technologies. Learn everything from fundamentals to system
>administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>
>  
>

Nate if you need help on the windows side of the house let me know. 
I would happy to test on simulator or whatever to help out.

I'm putting some time into the immediate goal of getting creating a
new stable release candidate, but I'm not getting that far.  The main
problem I'm hitting is that most of the outstanding bugs (or at least
the ones reported on the bug tracker) are specific to Tungsten users,
and I don't have a Tungsten to test on. 

For older Palms, there is an Emulator that runs well on Linux.  For
newer version (OS 5 and greater) there is a Simulator, but it's
Windows only, and I due to a medical condition (acute rage syndrome)
I'm not allowed to use Windows machines.  I just wasted a day trying
to see if I could make the Simulator run under Wine.  It almost
works---well enough that I can occasionally confirm a bug, but not
well enough to actually use for debugging.  And it turns out that Wine
is sufficiently close to Windows to have affected me (kill kill kill).

My first guess is that the bugs aren't actually Tungsten related, but
high-resolution related.  Perhaps because of the messed up nature of
the code, one needs to compile with "CONFIG_HANDERA" or "CONFIG_SONY"
to get the Tungsten to work properly.  But compiling with these
requires some proprietary SDK's which I don't have yet, so I haven't
tried that.  I'll try to get them later tonight.

Anyway, if anyone wants to step up and help with the Tungsten bugs,
that would be great.  And if anyone is good with making apps work with
wine (DLL disassembly and the like) help would be appreciated.  

--nate, hoping to fix the bugs so he can work on the new features

Welcome back, 

Marc?

Glad to hear you're OK. 

-----Original Message-----
From: pil...@li...
[mailto:pil...@li...] On Behalf Of
pil...@li...
Sent: Thursday, March 18, 2004 11:10 PM
To: pil...@li...
Subject: Pilot-db-list digest, Vol 1 #868 - 1 msg

Send Pilot-db-list mailing list submissions to

	pil...@li...

To subscribe or unsubscribe via the World Wide Web, visit

	https://lists.sourceforge.net/lists/listinfo/pilot-db-list

or, via email, send a message with subject or body 'help' to

	pil...@li...

You can reach the person managing the list at

	pil...@li...

When replying, please edit your Subject line so it is more specific

than "Re: Contents of Pilot-db-list digest..."

Today's Topics:

   1. Re:new improved 1.2.0 alpha 2 released (marc.chalain)

--__--__--

Message: 1

Date: Wed, 17 Mar 2004 11:29:28 +0100

Subject: Re:[pilot-db-list] new improved 1.2.0 alpha 2 released

From: "marc\.chalain" <mar...@la...>

To: "nate" <na...@ve...>

Cc: "pilot-db-list" <pil...@li...>

>     - Fixed crash in Sort dialogue  (917583)

>     - Fixed last record=

 uneditable  (917146)

Very old bugs already fix in previous versions.=0D

=

Sorry.

=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.la=

poste.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,3=

4=80/mn)=0A=0A

--__--__--

_______________________________________________

Pilot-db-list mailing list

Pil...@li...

https://lists.sourceforge.net/lists/listinfo/pilot-db-list

End of Pilot-db-list Digest

Hello,

I use pilot-db-1.1.0 (german) with my Clie JPEG 30 and it runs well. But
I always have troubles when I want to transfer a file to my Clie
Memorystick. I use the plugin "db-DB3vfs". The transfer is o.K., the
file is transfered to PALM/Launcher. But when I want to open it, there
is always an error "the file could not be opened". What can I do?

Regards
Robert Polzer

>     - Fixed crash in Sort dialogue  (917583)
>     - Fixed last record=
 uneditable  (917146)

Very old bugs already fix in previous versions.=0D
=
Sorry.

=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.la=
poste.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,3=
4=80/mn)=0A=0A

I've fixed all the bugs reported for db-1.2.0-alpha1.prc and have
just put up db-1.2.0-alpha2.prc.  Thanks to you who reported them.

    1.2.0 alpha 2:
    - configure changed: added --enable-fiveway (917590)
    - configure changed: added --enable-color
    - Fixed crash in Sort dialogue  (917583)
    - Fixed last record uneditable  (917146)

    1.2.0 alpha 1:
    - Fixed the popup regarding VLDB support
    - Other changes as yet undocumented as found in CVS

More testing would be appreciated.  My goal is to quickly make
something stable and mostly bug-free that we can call db-1.2.0, so
that we can move on to adding features and making things work better.

Please report bugs under group "v1.2" at:
<http://sourceforge.net/tracker/?group_id=621&atid=100621>

Thanks!

Nathan Kurz
na...@ve...

A few hours later than expected, but I have just released an alpha
version of what with some luck will one day be version 1.2.0: 

<http://sourceforge.net/project/shownotes.php?release_id=223964>

Currently, it is just a bare PRC file that one can use to upgrade
version 1.1.0.  It fixes the bug with VLDB popup message, but likely
introduces some new bugs.  

Bugs should be filed on the bug database using the group "v1.2":
<http://sourceforge.net/tracker/?group_id=621&atid=100621>

Testers apppreciated.  Bugs likely to be receive prompt attention.

--nate

Not directly, but it is in the same sense that Palm Datebook is 
compatible with PC through the Palm Desktop. There are two free 
applications for the desktop that open and manage Pilot-DB databases.

DB-Editor http://www.jakewalk.de <http://www.jakewalk.de/>
JPilot-DB http://www.chickenshick.com/jpilot-db/index.php

Hope this helps.
-TMcN-

Heather Allwood wrote:

> Can you please let me know if PilotDB is compatible with PC as well as 
> the OS operating system for PDA’s
>
> Many thank
>
> Heather
>
> Heather Allwood
>
> Education Liaison Officer
>
> Australian College of Rural & Remote Medicine
>
> PO Box 167
>
> Kelvin Grove DC Qld 4059
>
> Ph: 07 3352 8600
>
> Fax: 07 3356 2167
>

Can you please let me know if PilotDB is compatible with PC as well as
the OS operating system for PDA's

Many thank

Heather

=20

=20

Heather Allwood

Education Liaison Officer

Australian College of Rural & Remote Medicine

PO Box 167

Kelvin Grove DC  Qld  4059

Ph: 07 3352 8600

Fax: 07 3356 2167

=20

How i wrote the previous year, i stoped the Pilot-DB
development and i g=
ave the leading to Scott Wallace. But now i
have no news from him.

If=
 some body are interested to distribute some modifications i
can help hi=
m, to apply the patch to the official distribution
or to give him the ad=
ministration rights.

> Grrr... previous reply was off-list
> 
> > Ne=
w to the mailing list, even though I've used Pilot-DB
for a while now.=0D
=
> > But I recently upgraded my Pilot-DB program from 1.0.1 to
1.1, and s=
ome
> > icky
> > things happened.  First off, the fonts got huge, and I=

only have three
> > fonts
> > to choose from it seems.  Big, Bigger, =
and Biggest.  I
used to have a nice
> > tiny fint so that fields could =
actually fit in the window.
 I tried
> > downgrading back again at one =
point, but the fields were
all acting wierd.
> >
> > In addition, it's=
 a large DB I was loading up, and it kept
telling me
> > about
> > exp=
erimental DB size or something?  I'm not sure what the
whole message
> =
> was,
> > because half of it was behind the graffiti pad.
> >
> > I'm=
 using a Soy Clie PEG-NX60/U, and the Pilot-DB I loaded
off of the
> > =
website running this mailing list.
> 
> 
> Dunno about the fonts; on m=
y system (UX50 with FontsOS5 on
it) the font is
> whatever I set the sy=
stem font to.  So I can have a tiny
font, huge font
> or anything in-be=
tween.  And FontsOS5 lets me select a
different font set
> for each app=
lication, so I currently have a thinner smaller
font for DB
> than for =
everything else, so as to get more data on-screen.
 (One of these
> mon=
ths I will get Landscape support for the UX50 in there. <g>)
> 
> On th=
e warnings, I built a new prc without the large
database warning and
> =
mailed it to a few people.  One of them may mail it to you
today or I'll=

> do it this evening.  A newer build without that problem is
probably=0D
=
> available from CVS but has other significantly-modified code
too.
> =0D
=
> 
> -------------------------------------------------------
> This SF.=
Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial pre=
sented by Daniel Robbins, President
and CEO of
> GenToo technologies. L=
earn everything from fundamentals to
system
>
administration.http://ad=
s.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dclick
> __________________=
_____________________________
> Pilot-db-list mailing list
> Pilot-db-l=
is...@li...
> https://lists.sourceforge.net/lists/listinfo=
/pilot-db-list
> =0A=0AAcc=E9dez au courrier =E9lectronique de La Poste =
: www.laposte.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13=
 50 (0,34=80/mn)=0A=0A

I'm going through compiling to make a new snapshot CVS release.

Other than the VLDB dialog and the partially completed Microtime
stuff, does anyone know of any other easy to fix bugs in with the
current version?  I'm starting to look through the bugs list
<https://sourceforge.net/tracker/?group_id=621&atid=100621>, but
figured maybe you all might be a better source of info.

A related question:  does anyone know what compile options I should
use for the snapshot release?  Obviously I can figure something out,
but I was wondering if anyone know what the precedent has been.

--nate

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