pilot-db-list

[pilot-db-list] Mac sync question

[Michael C. M. <mm...@pe...>]

I have been looking through the back mail list messages, and cannot 
find if the Mac sync issue has been resolved. My palm crashed, and I 
cannot get my databases to open after transferring the backup dbs to 
the Palm.

Michael Miller


This email has been scanned for viruses by MessageLabs.

[pilot-db-list] Software

[claudia <cla...@ho...>]

Ol=E1

Gostaria de saber se =E9 poss=EDvel fazer um programa espec=EDfico para =
empresa, em que possamos us=E1-lo na Palm e no PC.
Favor entrar em contato atrav=E9s do tel. (11) 9145-2025.


Atenciosamente,
Claudia Boson

Re: [pilot-db-list] Pilot DB =?ISO-8859-1?Q?Fran=E7ais?=

[Thomas R. <tr...@or...>]

FAURE C=E9dric wrote:
> Comment faut-il installer le logiciel Pilot DB sur un palm III
> Merci
>=20

t=E9l=E9charger l'archive db-1_0_4.zip (ou pilot-db-1_1b2.zip pour la=20
derni=E8re version beta)
A l'aide du Palm Desktop, installer les fichiers suivants:
db.prc
overlay\help-fr.prc (pour avoir l'aide en Fran=E7ais)
overlay\overlay-fr.prc (pour traduire les menus en Fran=E7ais)

Thomas

[pilot-db-list] =?iso-8859-1?Q?Pilot_DB_Fran=E7ais?=

[<ced...@cs...>]

Comment faut-il installer le logiciel Pilot DB sur un palm III
Merci

Cédric Faure
Process Engineer,
Materials for Microsystems
Surface Engineering
ced...@cs...

[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Copyright/Licence_Questions?=

[=?iso-8859-1?Q?<mar...@la...>]

I disagree with this pratice and i'm disapointed but i think=0D=0Athey ar=
e the right to do that. Every body can do that, but=0D=0Athey must stay t=
he copyright inside the software.=0D=0AI will ask somebody about that.=0D=
=0A---------- Debut du message initial -----------=0D=0A=0D=0ADe     : pi=
lot...@li...=0D=0AA      : <pilot-db-list@list=
s.sourceforge.net>=0D=0ACopies : =0D=0ADate   : Mon, 7 Apr 2003 18:59:57 =
+0200=0D=0AObjet  : [pilot-db-list] Copyright/Licence Questions=0D=0A=0D=0A=
Hi,=0D=0A=0D=0AI have noticed that a company called 9.95 soft (search for=
=0D=0A"9.95" in=0D=0APalmgear)=0D=0Acopies OpenSource GNU GPL software, c=
hanges the name and the=0D=0Aoptics a little=0D=0Abit and sells the softw=
are for 9.95$. They might do this with=0D=0APilot-DB too.=0D=0A=0D=0Ahttp=
://www.palmgear.com/software/showsoftware.cfm?sid=3D449245D1-070E-4BF5-9D=
6=0D=0AD117CD3A566A2&prodID=3D47895=0D=0A=0D=0AAll the programs that they=
 offer have been copied.=0D=0ANone of them have been developed by the Com=
pany!=0D=0A=0D=0A9.95 Safe copied from KeyRing=0D=0A9.95 Chess copied fro=
m OpenChess=0D=0A9.95 Calc copied from  Bez Calculator=0D=0A9.95 Clock co=
pied from BigClock=0D=0A9.95 Fuel copied from Fuel Log=0D=0A9.95 Bible co=
pied from Bible Reader=0D=0A=0D=0AAll the above programs were developed u=
nder the GNU GPL License.=0D=0A=0D=0AAfter discussing with them they have=
 finally added a note=0D=0Astating the=0D=0Aprograms on which their progr=
ams are based on.=0D=0A=0D=0AA hidden link to the source files is also av=
ailable.=0D=0A=0D=0AStill, are the allowed to sell their slightly (optica=
lly) changed=0D=0Asoftware??=0D=0A=0D=0AHere is an excerpt of the GPL lic=
ence:=0D=0A=0D=0A  2. You may modify your copy or copies of the Program o=
r any=0D=0Aportion=0D=0Aof it, thus forming a work based on the Program, =
and copy and=0D=0Adistribute such modifications or work under the terms o=
f Section 1=0D=0Aabove, provided that you also meet all of these conditio=
ns:=0D=0A=0D=0A    a) You must cause the modified files to carry prominen=
t=0D=0Anotices=0D=0A    stating that you changed the files and the date o=
f any change.=0D=0A=0D=0A    b) You must cause any work that you distribu=
te or publish,=0D=0Athat in=0D=0A    whole or in part contains or is deri=
ved from the Program=0D=0Aor any=0D=0A    part thereof, to be licensed as=
 a whole !!!!!!!!!! at no=0D=0Acharge to all=0D=0Athird=0D=0A    parties =
under the terms of this License!!!!!!!!!.=0D=0A=0D=0AIs this permitted in=
 your opinion. If not, would you help me=0D=0Aprotest?=0D=0A=0D=0AThanks,=
=0D=0A=0D=0AHans Ajiet Holtkamp=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A------=
-------------------------------------------------=0D=0AThis SF.net email =
is sponsored by: ValueWeb: =0D=0ADedicated Hosting for just $79/mo with 5=
00 GB of bandwidth! =0D=0ANo other company gives more support or power fo=
r your=0D=0Adedicated server=0D=0Ahttp://click.atdmt.com/AFF/go/sdnxxaff0=
0300020aff/direct/01/=0D=0A______________________________________________=
_=0D=0APilot-db-list mailing list=0D=0AP...@li...=
t=0D=0Ahttps://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A=0A=
=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A=
3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A=

Re: [pilot-db-list] Copyright/Licence Questions

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

> All the programs that they offer have been copied.
> None of them have been developed by the Company!
> 
> 9.95 Safe copied from KeyRing
> 9.95 Chess copied from OpenChess
> 9.95 Calc copied from  Bez Calculator
> 9.95 Clock copied from BigClock
> 9.95 Fuel copied from Fuel Log
> 9.95 Bible copied from Bible Reader
> 


	I checked out their web site, and they do have links to the source 
code (although I didn't actually d/l anything).  I think they can sell it 
if they want to, they just need to state that it's based on GPL code, give 
credit to the authors and allow anyone to get the source code of their new 
program for free (which they seem to do....)

	I agree that it's a pretty lame idea. Perhaps that's why they 
don't seem to be getting very many downloads.

	But perhaps some other people on this list can ring in on their 
opinions.  We can always send mail to the free software foundation, I 
think they're the ones that try to keep up on this sort of thing...


	-Scott

	(BTW, I didn't see anything that looked like a take of off db, 
perhaps they haven't figured out how to compile it yet ;)  )


	

[pilot-db-list] Copyright/Licence Questions

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

Hi,

I have noticed that a company called 9.95 soft (search for "9.95" in
Palmgear)
copies OpenSource GNU GPL software, changes the name and the optics a little
bit and sells the software for 9.95$. They might do this with Pilot-DB too.

http://www.palmgear.com/software/showsoftware.cfm?sid=449245D1-070E-4BF5-9D6
D117CD3A566A2&prodID=47895

All the programs that they offer have been copied.
None of them have been developed by the Company!

9.95 Safe copied from KeyRing
9.95 Chess copied from OpenChess
9.95 Calc copied from  Bez Calculator
9.95 Clock copied from BigClock
9.95 Fuel copied from Fuel Log
9.95 Bible copied from Bible Reader

All the above programs were developed under the GNU GPL License.

After discussing with them they have finally added a note stating the
programs on which their programs are based on.

A hidden link to the source files is also available.

Still, are the allowed to sell their slightly (optically) changed
software??

Here is an excerpt of the GPL licence:

  2. You may modify your copy or copies of the Program or any portion
of it, thus forming a work based on the Program, and copy and
distribute such modifications or work under the terms of Section 1
above, provided that you also meet all of these conditions:

    a) You must cause the modified files to carry prominent notices
    stating that you changed the files and the date of any change.

    b) You must cause any work that you distribute or publish, that in
    whole or in part contains or is derived from the Program or any
    part thereof, to be licensed as a whole !!!!!!!!!! at no charge to all
third
    parties under the terms of this License!!!!!!!!!.

Is this permitted in your opinion. If not, would you help me protest?

Thanks,

Hans Ajiet Holtkamp

[pilot-db-list] how to do a "rebuild"

[Trever M. S. <tre...@co...>]

Hi, it's me again.

I need to change the GUI so that I can edit, not just create table
schemas...
My question is this.  In pilot-db on the palm, when you alter your schema,
what are the rules for rebuilding?

What types can be converted to what, and what happens when columns change
positions?

Is there a function in the C code that I can read to figure this out?

Trever

[pilot-db-list] Examples Needed Please

[Trever M. S. <tre...@co...>]

Hi, I've been working on CSV import for the JPilot-DB (
http://jpilot-db.sourceforge.net ) tools and GUI and I think I have it
working well. However, I'd like to write more tests for my CSV parser, so if
you have any db-tools IFO configuration files and CSV files ( like test.ifo
and test.csv) that you use regularly. If you could send them to me I'd
really appreciate it.  Please send to tre...@co... .

BTW, the csv import GUI is working within the JPilot-DB GUI.  However, it's
just in CVS now, so it's not in the release yet...

Thanks!

Trever M. Shick

[pilot-db-list] Submit your site - Agregar tu web - URL anmelden

[Fine A. D. <un...@ar...>]

<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>art-online TM - The Fine Art Directory</title>
<meta name="ROBOTS" content="NOINDEX">
<style type="text/css">
<!--
td {  font-family: Arial}
a:link {  color: #000000; text-decoration: none; font-weight: 600; line-height: 20px}
a:hover {  color: #FF0099; text-decoration: none; font-weight: 600; line-height: 20px}
a:visited {  text-decoration: none; font-weight: 600; line-height: 20px}
-->
</style>
<!--8941316_23-->
</head>
<body bgcolor="#FFFFFF">
<!--8941316_23--> 
<table width="280" border="0" cellspacing="0" cellpadding="0" align="center" height="92">
<form method="get" action="http://www.art-online.com/search.aspx" id="search">
<tr height="92"><td background="http://www.art-online.com/img/med/nadar_art_online.jpg" 
width="280" height="92"  align="center" valign="bottom"> 
<table border="0" cellpadding="0" cellspacing="0">
<tr><td nowrap align="center" valign="bottom">
<input type=text name=q size=20>
<input type=submit value="search">
</td></tr></table>
</td></tr></form></table>
<table width="400" border="0" align="center">
<tr><td align="center"><font size="1" color="#9C9ACE">
T&nbsp;&nbsp;H&nbsp;&nbsp;E&nbsp;&nbsp;&nbsp;&nbsp;F&nbsp;&nbsp;I&nbsp;&nbsp;N&nbsp;&nbsp;E&nbsp;&nbsp;&nbsp;&nbsp;A&nbsp;&nbsp;R&nbsp;&nbsp;T&nbsp;&nbsp;&nbsp;&nbsp;D&nbsp;&nbsp;I&nbsp;&nbsp;R&nbsp;&nbsp;E&nbsp;&nbsp;C&nbsp;&nbsp;T&nbsp;&nbsp;O&nbsp;&nbsp;R&nbsp;&nbsp;Y</font></td>
</tr></table>
<br>
<table width="693" border="0" align="center">
<tr> 
<td><ul>
<li><a href="http://www.art-online.com/category.aspx?id=98">Art History</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=100">Art Market</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=95">Art Venues</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=62">Artists</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=92">Education</a></li>
</ul></td>
<td><ul>
<li><a href="http://www.art-online.com/category.aspx?id=830">Employment</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=90">Events</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=60">Galleries</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=93">Governments</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=97">Legal</a></li>
</ul></td>
<td><ul>
<li><a href="http://www.art-online.com/category.aspx?id=61">Museums</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=99">Professionals</a></li>
<li><a href="http://www.art-online.com/category.aspx?id=91">Resources</a></li>
<li><A href="http://www.art-online.com/category.aspx?id=101">Rewards</A></li>
<li><a href="http://www.art-online.com/category.aspx?id=96">Shopping</a></li>
</ul></td></tr>
<tr><td colspan="3">
<blockquote>
<H2><A href="http://www.Art-Online.com/category.aspx?id=0"><B>Visit our directory</B></A><B> 
&amp; <A href="http://www.art-online.com/help.aspx#submit">Submit your site!</A></B></H2>
<ul><B>To submit a URL: </B> 
<li><FONT color="#FF0099"><B>Navigate through the Directory to identify the appropriate 
category</B></FONT>.</li>
<li> <FONT color="#FF0099"><B>Enter the category, and click on &quot;Submit&quot;</B></FONT>.</li>
</ul>
<ul>
<B>Choose the Priority Submission:</B> 
<li><FONT color="#FF0099"><B>39 Euros only</B></FONT></li>
<li>the only guarantee that your submission will be processed by an art-online editor 
within <FONT color="#FF0099"><B>3&nbsp;business days</B></FONT>.</li>
<li>If your submission is accepted, your website will be indexed <B><FONT color="#FF0099">for 
an unlimited period of time</FONT></B>.</li>
</ul>
<H3><A href="http://www.Art-Online.com/category.aspx?id=0">Submit now</A></H3>
</Blockquote>
<p>Because of the great number of submissions, the standard submissions will not be 
processed before several months.</p>
<P align=center><I><FONT size="2">Edited and updated by a human team</FONT></I><br>
<A href="http://www.art-online.com">http://www.art-online.com</A></p></td></tr></table>
<br><br><br><br><br><br><br><br><br>
<FONT face="Arial" size="2">
<b>To remove</b> your email: pil...@li...<br>
please click below:<br><a 
href='http://list.artists-server.com/?m=pilot-db-list%40lists.sourceforge.net'>
http://list.artists-server.com/?m=pil...@li...
</a><br>
In case the above link does not work you can go to<br>
http://list.artists-server.com/<br>

or reply to this message as it is.<br>
Please allow us 72 H for your e-mail to be removed.<br>Thank you for your co-operation.
<br>
<br>
<b>Pour désinscrire</b> votre email : pil...@li...<br>
cliquez ci-dessous :<br><a 
href='http://list.artists-server.com/?m=pilot-db-list%40lists.sourceforge.net'>http://list.artists-server.com/?m=pil...@li...</a><br>
Si le lien ci-dessus ne fonctionne pas, vous pouvez aller sur :<br>
http://list.artists-server.com/
<br>ou répondez svp à ce message sans en modifier le contenu.<br>

Votre désinscription sera effective dans les 72 H.<br>Merci de votre coopération.
</font>
<br>
<FONT face="Arial" size="1"> En conformit&eacute; avec la loi 78-17 du 6/1/78 (CNIL), vous pouvez 
demander &agrave; ne plus figurer sur notre fichier de routage.</font>
</body></html>

Re: [pilot-db-list] Category Support

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

On Fri, 4 Apr 2003, Larry K. Turner wrote:

> >>> Scott Wallace <swa...@my...> 04/03/03 07:02PM >>>
> 
> >Wouldn't this be best defined as simply another field in the database,
> >like a list?  You could easily emulate categories with such a field and
> >a set of filters, and this is a much more >powerful representation.
> 
> I have not found a way to edit one entry in a list and keep the
> information intact in the DB.  If you have alot of records under that
> category and need to change it you have to go back and change them all
> individually.

	Hm. Good point. I will think about this.

> 
> If you could edit a list entry this would work ok.
> 
> Also , you can have 15 Categories in the default Palm OS applications,
> but you only have 4 filters.
> 

	In 1.1 you can have lots of filters, 32 I think.

	-Scott

Re: [pilot-db-list] Category Support

[Larry K. T. <LK...@me...>]

>>> Scott Wallace <swa...@my...> 04/03/03 07:02PM >>>

>Wouldn't this be best defined as simply=20
>another field in the database, like a list?  You could easily emulate=20
>categories with such a field and a set of filters, and this is a much more=
 >powerful representation.

I have not found a way to edit one entry in a list and keep the information=
 intact in the DB.  If you have alot of records under that category and nee=
d to change it you have to go back and change them all individually.

If you could edit a list entry this would work ok.

Also , you can have 15 Categories in the default Palm OS applications, but =
you only have 4 filters.


Thanks
Larry



---------------------------------------------------------------------------=
----------------
Note:  Please update your email address for this user to reflect the=20
new MeadWestvaco Corporation.  MeadWestvaco employee=20
email addresses are in the format of  us...@Me...

This electronic message contains information from MeadWestvaco
Corporation or subsidiary companies, which may be confidential,
privileged or otherwise protected from disclosure.  The
information is intended to be used solely by the recipient(s)
named.  If you are not an intended recipient, be aware that
any review, disclosure, copying, distribution or use of this
transmission or its contents is prohibited.  If you have
received this transmission in error, please notify MeadWestvaco
immediately at pos...@Me....
---------------------------------------------------------------------------=
----------------


________________________________________________________________________
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20SkyScan
service._______________________________________________________________

Note:=20=20Please=20update=20your=20email=20address=20for=20this=20user=20=
to=20reflect=20the
new=20MeadWestvaco=20Corporation.=20=20MeadWestvaco=20employee=20email=20a=
ddresses
are=20in=20the=20format=20of=20...@Me...=20

This=20electronic=20message=20contains=20information=20from=20MeadWestvaco=

Corporation=20or=20subsidiary=20companies,=20which=20may=20be=20confidenti=
al,
privileged=20or=20otherwise=20protected=20from=20disclosure.=20=20The
information=20is=20intended=20to=20be=20used=20solely=20by=20the=20recipie=
nt(s)
named.=20=20If=20you=20are=20not=20an=20intended=20recipient,=20be=20aware=
=20that
any=20review,=20disclosure,=20copying,=20distribution=20or=20use=20of=20th=
is
transmission=20or=20its=20contents=20is=20prohibited.=20=20If=20you=20have=

received=20this=20transmission=20in=20error,=20please=20notify=20MeadWestv=
aco
immediately=20at=20p...@Me....
_______________________________________________________________________

Re: [pilot-db-list] Category Support

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

> I looked in the List Archives, but didn't find about this.
> 
> Does DB support Categories at the record level as ThinkDB/SmartList does?
> If not, is there any plan to add this?

	Nope. Nope.  DB uses Categories to identify items from recent 
searches, and to quickly swap between different filters, so the category 
data structure is already in use.  But perhaps the greater question is why 
would you want categories per se?  Wouldn't this be best defined as simply 
another field in the database, like a list?  You could easily emulate 
categories with such a field and a set of filters, and this is a much more 
powerful representation.

> 
> Great app and getting better all the time.
> Larry
> 

	Glad you like it!

		-Scott

[pilot-db-list] Category Support

[Larry K. T. <LK...@me...>]

I looked in the List Archives, but didn't find about this.

Does DB support Categories at the record level as ThinkDB/SmartList does?
If not, is there any plan to add this?

Great app and getting better all the time.
Larry



---------------------------------------------------------------------------=
----------------
Note:  Please update your email address for this user to reflect the=20
new MeadWestvaco Corporation.  MeadWestvaco employee=20
email addresses are in the format of  us...@Me...

This electronic message contains information from MeadWestvaco
Corporation or subsidiary companies, which may be confidential,
privileged or otherwise protected from disclosure.  The
information is intended to be used solely by the recipient(s)
named.  If you are not an intended recipient, be aware that
any review, disclosure, copying, distribution or use of this
transmission or its contents is prohibited.  If you have
received this transmission in error, please notify MeadWestvaco
immediately at pos...@Me....
---------------------------------------------------------------------------=
----------------


________________________________________________________________________
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20SkyScan
service._______________________________________________________________

Note:=20=20Please=20update=20your=20email=20address=20for=20this=20user=20=
to=20reflect=20the
new=20MeadWestvaco=20Corporation.=20=20MeadWestvaco=20employee=20email=20a=
ddresses
are=20in=20the=20format=20of=20...@Me...=20

This=20electronic=20message=20contains=20information=20from=20MeadWestvaco=

Corporation=20or=20subsidiary=20companies,=20which=20may=20be=20confidenti=
al,
privileged=20or=20otherwise=20protected=20from=20disclosure.=20=20The
information=20is=20intended=20to=20be=20used=20solely=20by=20the=20recipie=
nt(s)
named.=20=20If=20you=20are=20not=20an=20intended=20recipient,=20be=20aware=
=20that
any=20review,=20disclosure,=20copying,=20distribution=20or=20use=20of=20th=
is
transmission=20or=20its=20contents=20is=20prohibited.=20=20If=20you=20have=

received=20this=20transmission=20in=20error,=20please=20notify=20MeadWestv=
aco
immediately=20at=20p...@Me....
_______________________________________________________________________

Re: [pilot-db-list] Some ideas

[Martin B. <mar...@pa...>]

Hello.

> > 1- On DB list screen, if I tap on database, not whole line is inverted,
> > baseline to bottom of the line stays "black text on white"
> 
>  Hmm.  I don't see this.  Is it on all db's or just one in a 
> specific location...  If you move the stylus, then some minor changes to 
> the highlighting do occur, but that is to indicate that you can reorder 
> the list.

All databases. from baseline to top, the line is inverted. From baseline
down, it is not (e.g. the below-the-line parts of 'y', 'p', 'g' etc. is
still black on ... err... green :-)

And if I move the stylus, nothing changes, stil the same db is selected.

> > 4- Filters - I think that "search" is not sufficient for filtering. One
> > would expect more operators, like "is not empty", "is not equal to", "is
> > equal to" etc. I hope for one of the next versions (well, I have to read
> > some todo documents...)
> 
>  Actually, you can use scripts in the search dialog too ;)  I don't 
> think this is documented...

Yes, those scripts are nice, someone from this list already wrote me
about scripts... Nice!

> > 6- Record view: reading - I still can change values from "select one
> > value from the dropdown list" columns, although edit lines are read
> > only. I was very confused when I encountered this for the first time :-)
>  
>  Good point.  I don;t know how easy this is to fix, but I will look 
> into it.

In fact, I can work with dropdown lists, but actual value doesn't
change... This was my fault. Nevertheless it would be nice if it was not
possible to use dropdown list in any way.

> > 7- Recocr view: note fields - is it possible to show the whole note
> > field possibly with ruler on the side if the text is longer? It would be
> > of a good help for my cooking database, I keep cooking instructions in 
> > a note field and I have to click the note icon... This would be *very*
> > nice feature!
> 
>  Do you mean without clicking on the note icon?

Yes, exactly. Now I have to tap the note icon - either I can see the
record, or one note field. Not both together. (Consider my example with
cook book - I have to view ingredients list as well as cooking
instructions, and working with the stylus is not very good for it or for
Handera itself while your'e cooking...)

> > If you would like to have Czech translation, I would be happy to help
> > you prepare the translation...
> 
>  It'd be great to have a Czech translation.  If you want, there is 
> a sample translation file included in the source code release.  It has 
> instructions for the translation.  If your downloads are limited, I can 
> also email you a copy.

OK, I will try to make a translation file.
Martin

-- 
Martin Bodlak, Ostrava, CR
---> www.palmknihy.cz <---
mar...@pa...

Re: [pilot-db-list] Some ideas

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

On 21 Mar 2003, Martin Bodlak wrote:

> Hello, I am new to this list.
> 
> First, thank you for nice application. I use it not so heavily, e.g. for
> cooking recipes :-) or radio stations available in my city... It is the
> only free database available for my Handera! Wow!
> 
> Now I have some notes on versin 1.1.0b1, they are of low importance, but
> someone have to tell it :-) - But hey, I still love the app! :-)))
> 
> 1- On DB list screen, if I tap on database, not whole line is inverted,
> baseline to bottom of the line stays "black text on white"

	Hmm.  I don't see this.  Is it on all db's or just one in a 
specific location...  If you move the stylus, then some minor changes to 
the highlighting do occur, but that is to indicate that you can reorder 
the list.

> 
> 2- Most dialogs (e.g. Create Database) have bad dimensions - they have
> no right and left edges. I think you set the position too left and width
> too much. But as far as I can see starting curve of the dialog edge, I
> think it is about 2-3 pixels position and double for the width.
> 

	This is fixed in the latest version, I believe.

> 3- The issue with VFS was mentioned in the posting a few hours ago :-) I
> too think that there should be some directory like /Palm/Programs/DB or
> PilotDB or whatever do you wish.

	Ok. (Hopefully fixed, or soon to be)
> 
> 4- Filters - I think that "search" is not sufficient for filtering. One
> would expect more operators, like "is not empty", "is not equal to", "is
> equal to" etc. I hope for one of the next versions (well, I have to read
> some todo documents...)

	Actually, you can use scripts in the search dialog too ;)  I don't 
think this is documented...

	so, if you put (not (seq %1 cheese)) in the filter, it will find 
the records that have field 1 set to something other than 'cheese'.


> 6- Record view: reading - I still can change values from "select one
> value from the dropdown list" columns, although edit lines are read
> only. I was very confused when I encountered this for the first time :-)
> 
	
	Good point.  I don;t know how easy this is to fix, but I will look 
into it.


> 7- Recocr view: note fields - is it possible to show the whole note
> field possibly with ruler on the side if the text is longer? It would be
> of a good help for my cooking database, I keep cooking instructions in 
> a note field and I have to click the note icon... This would be *very*
> nice feature!
> 

	Do you mean without clicking on the note icon?


> Anyway, Pilot-DB is very nice application - among the other things it is
> one of apps with Handera support! Thanks a lot!


	Thanks!
> 
> Martin
> 
> If you would like to have Czech translation, I would be happy to help
> you prepare the translation...
> 
	It'd be great to have a Czech translation.  If you want, there is 
a sample translation file included in the source code release.  It has 
instructions for the translation.  If your downloads are limited, I can 
also email you a copy.


	-Scott

-- 

Re: [pilot-db-list] Question about Calculated Fields PDB Format

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

Trever,
	I put an updated copy of script.c into CVS today.  It documents 
the mapping between various operators and their bytecode (examples, 
however, are yet to be included ;) )


	hope this helps,

	-Scott

[pilot-db-list] Would you be interested in distributing your software on PDAGreen.com?

[Dominik O. <do...@pd...>]

Would you be interested in adding your Palm software to PDAGreen=2Ecom, a =
new Palm os oriented software store? To make this worthwhile, we will take=
 15% commission on all sales until January 1st, 2004 with no additional fe=
es! We will take 20% commission on all sales after January 1st=2E

Reply to Matt Stein matt@PDAGreen=2Ecom

You can also contact us by phone:
(+1) 313-259-3016 (Monday - Friday, 9AM - 5PM EST)=2E

Best regards,

      Dominik Oslizlo, Webmaster
      PDAGreen=2Ecom
      http://www=2Epdagreen=2Ecom
      Natural Selection!(tm)

PS: We never missed a payment to our developers in over 3 years=2E=2E=2E C=
heck out our affiliated website, PocketGear=2Ecom where since 1998
we have continuously paid ALL our software developers ON TIME EVERY MOTNH=2E=
 We represent over 3,000 software developers=2E=2E=2E=2E

[pilot-db-list] Keyboard thoughts

[Craig B. <cr...@bo...>]

Feature suggestion:
It occurs to me that a good deal of Palm Portable keyboard support is
already in Pilot-DB with the jog dial code.

There's just some small areas that would really finish off the ability to
get basic keyboard functional.

The Handera Jog dial simply sends Fieldnext and FieldPrev virtual
characters.  These can also be entered with graffiti and the up down
cursors on the Palm portable keyboard.

Thus, once you've pushed in the jog dial, you can in fact navigate the
highlight bar with either the PPK or graffiti currently from record to
record in the record list view, or field to field in a record.

In fact the record edit view is even better because the highlight bar
appears as soon as you enter the FieldNext or FieldPrev virtual character
either by graffiti or the keyboard.  There's no need to first push the
jog dial in.  It might be nice if the record list mode worked this was
too, as other jog dial enabled apps do.  I note you can also bring up the
highlight bar in the record list by hitting Enter on the keyboard, and
the record is selected (opened for editing) with an additional Enter
press.  It just seems to me that the highlight bar should work the same
way in the record list view as is does in the record edit mode (i.e.
appear as soon as you enter a FieldNext or FieldPrev virtual character).

The remaining issues that would need additional coding...

-Currently there doesn't seem to be a keyboard or graffiti action that
can set focus on the field.  Meaning that when jogging or FieldNext'ing
to a record field, even though the cursor blinks in that field you can't
input text with either graffiti or the keyboard.  You first need to tap
the field.  Once you've tapped on a field with the stylus, you can enter
text in any other field regardless if you navigate to it with the jog
dial, Tab/Shift Tab character, or FieldNext FieldPrev character.  It's
just that initial tap that's getting in the way.

-There's seems to be no way to exit the record via graffiti or keyboard.
And here too there seems to be a Handera jog dial inconsistency.  With
the jog dial you can leave the record with either the back/escape button,
or by pushing in the jog dial.  So pushing in the jog dial both enters
and exits the record.  Normally only the back/escape button should exit.
And while enter (keyboard or graffiti) enters into a record from the list
mode, enter doesn't save the record and return you to the list view.  For
good keyboard support, any or all of the keyboard virtual characters for
Enter, OK, and Done could/should do this.

-And the last remaining function to support would seem to be the "New"
virtual character.  Which is "Fn Space" on the PPK.  Both in the Record
list mode to start a new record, and the Database list view to start a
new database.  Though I'm aware in the record list view this can be
accomplished with Command N, it would be good to trap for both.

It nice that most of the other major menu options have Command shortcuts
that can be leveraged with the keyboard.

I just wonder if Enter virtual character (graffiti and keyboard) might be
trapped in many of the dialogs for activating the default button.

For example you can bring up Find a database with Command F, and the
focus is set on the text field so you can immediately enter the text to
find.  However if the Enter character was trapped for you wouldn't have
to tap the Find button.  At the end of the text entry you could enter the
diagonal stroke if you using graffiti entry, or the Enter key on the
keyboard.  There is a work around in the mean time for those with a good
memory for keyboard tricks, you can hold Ctrl and Alt and the first
letter of the onscreen button you want to push (in this case F for Find),
and "push" the button with the keyboard.  The feature doesn't work in
dialogs with two buttons starting with the same letter, and I haven't
checked to see if any of those occur in Pilot-DB.

Anyway, a but of a ramble, but hopefully some useful thoughts.

On a side note I'm amazed you got so much functionality in Pilot-DB
already with the current small size.  I noticed the other day that
SmartList/ThinkDB is over 500K now.  It's got more polish, glitz and
*some* nice stuff,  there's no way it has almost 400K worth of more
functionality.  And in a couple areas it has some catch-up to do since
1.1B2

[pilot-db-list] Re: Jpilot-db

[Larry W. V. <lv...@ca...>]

If readers have not yet tried jpilot-db, I have to say, this is the first
Java GUI Application that I've seen, since the first time Java was
introduced 'eons' <grin> ago that gives me hope that Java is a viable
programming language.

Jpilot-db comes up faster than any other Java application I have seen,
the application works very nicely - certainly there are things that a
user such as myself which uses primarily Unix has to learn about the
MDI interface, but I found it easy enough to learn.

Earlier versions of JPilot-db had some things about it that I found
confusing, but the developer has enthusiastically been improving the
application (and fixing bugs) on a regular basis.  

I know I encourage anyone like myself who has always thought "yuck, Java,
too slow, too ugly, etc." to give the application a look, particularly if
you find Windows only applications at best unusable (since I only have
access to Unix systems most of the week).
-- 
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.
-><-

[pilot-db-list] =?iso-8859-1?Q?Jpilot-db?=

[=?iso-8859-1?Q?<mar...@la...>]

I tried your application, i like it and i will give you my=0D=0Apoint of =
vue:=0D=0A - Java is slow.=0D=0A + Java works on every OS. (i will try th=
is night on my Linux box)=0D=0A - you distribute a lot of packages and i =
don't know what is=0D=0Athe good file to use it easily. Some of the packa=
ges are very=0D=0Alarges, and my RTC line doesn't permit me to download e=
verything.=0D=0A + after the application starting, it runs fast.=0D=0A + =
the GUI looks like the Palm application for the icons ( i=0D=0Afind that =
if the application keeps more parts of the Pilot-DB=0D=0AGUI, it will be =
easier for the users but i'm not a good=0D=0Areference :).=0D=0A - the fi=
rst starting. I didn't understand that i need to=0D=0Aselect a directory =
and that i will see the databases inside=0D=0Athis directory. A good idea=
 is to ask the directory to use at=0D=0Athe first time and store the path=
 for the next using. (i=0D=0Ashould read the help file but i'm not patien=
t).=0D=0A - i read the source code of the first version, i didn't=0D=0Aun=
derstand the directories structure and i had a lot of=0D=0Adifficultes to=
 enter inside your source code.=0D=0A=0D=0AI think it's a very good tool =
and we have two concurrents with=0D=0ADBEditor (+ Palm-DB-Tools). It's no=
t a bad thing, jpilot-db=0D=0Aruns on every platforms and DBEditor are fa=
ster. I think that=0D=0Ayour distribution is not clear. You have too many=
 packages,=0D=0Aand it's impossible for everybody to download everything.=
 I=0D=0Awill use it now (i work on Linux).=0D=0A=0D=0ASalut,=0D=0AMarc.=0A=
=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A=
3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A=

Re: [pilot-db-list] Question about Calculated Fields PDB Format

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

> I'm looking for the internal structure of the calculated field's data in a
> record
> as well as the bytecode "language"...

Hmm.  May I should make a document about this ;)

	I will give you a quick overview, and then try to add details over 
the weekend and send you the notes:

	There are two important data structures for calculated fields, the 
stored values themselvs which I believe is covered in the format.txt that 
has been circulating, and the scripts.  I'll just go into the scripts 
here.

	 Scripts are stored in the AppInfoBlock, a normal script (i.e. one
that is associated with a field in the schema) is stored in the field's
CHUNK_FIELD_DATA chunk.  This has the following format:

	Int8	bytecode_sz;
	Int8	version_flag		(currently 0x20)
	Int8	access_requirements	(see below)
	Int8	returnType		(return type, if known)
	Int8	bytecode[]		(an array of bytecode_sz)
	

	Access Requirements:

	This indicates wht the script is going to do, it is a set of flags 
selected from:

NO_EXTERNAL_ACCESS	// is completely self contained
FIELD_READING		// reads fields from a record
SINGLE_RECORD_READING	// reads fields within a single 'current' record 
MULTI_RECORD_READING	// reads fields from multiple records
ARRANGING		// may move/reorder records


All of the info in this structure is determined when the script is 
compiled, and depends on the exact set of operations that are used in the 
script.


Because I didn't want to store the text version of the script and the 
bytecode, I made a bytecode compiler that would allow the original script 
to be recovered after a decompilation process.  This means that there are 
some aspects of the bytecode that are perhaps redundant or overly verbose, 
but in all does save space.

Basically, all the compiler does is map the text strings onto tokens in 
the bytearray.

	Tokens are delimilated by one of these flags:

ENTER_8_BIT          (1) (a function pointer)
ENTER_16_BIT 	     (2) (a function pointer, plus an 'invisible' argument)
EXIT                 (3) (end of function arguments)
FIELD_NAME_REFERENCE (4) (not used)
FIELD_ID_REFERENCE   (5) (a reference to a field)
LITERAL_STRING       (6)
LITERAL_INTEGER      (7)
LITERAL_FLOAT        (8)
LITERAL_DATE         (9)
LITERAL_TIME         (10)



	Ok, I just realized this is a bit complicated for a quick 
overview, and you're definitely going to need to look a bit at the C code.  
This weekend, however, I will lay out an overview of how the bytecode is 
generated, and illustrate some examples.  I'll put this all into script.c 
so it will be easy (hopefully) to see how things are working.

	-Scott

[pilot-db-list] RESEND-Question about Calculated Fields PDB Format

[Trever M. S. <tre...@co...>]

> I'm looking for the internal structure of the calculated field's data in a
> record
> as well as the bytecode "language"...
>
> basically, my project (jpilot-db.sourceforge.net) supports all the fields
> now except calculated and i'd love to put the calculated field in.
However,
> I don't have the information. I suppose I could figure it out, but I was
> hoping that somebody on this list intimately familiar with the byte
> code/calculated field could help me.
>
> Trever M. Shick
> http://jpilot-db.sourceforge.net
>

[pilot-db-list] Question about Calculated Fields PDB Format

[Trever M. S. <tre...@co...>]

I'm looking for the internal structure of the calculated field's data in a
record
as well as the bytecode "language"...

basically, my project (jpilot-db.sourceforge.net) supports all the fields
now except calculated and i'd love to put the calculated field in.  However,
I don't have the information. I suppose I could figure it out, but I was
hoping that somebody on this list intimately familiar with the byte
code/calculated field could help me.

Trever M. Shick
http://jpilot-db.sourceforge.net

[pilot-db-list] DB editor

[<fe...@io...>]

Dear sir,
Is there a possible to import ASCII and DBF files to desktop version?

Thanks
Jiri Ruzicka
e-mail: fe...@io...
---
Odchoz=ED zpr=E1va neobsahuje viry.
Zkontrolov=E1no antivirov=FDm syst=E9mem AVG (http://www.grisoft.cz).
Verze: 6.0.463 / Virov=E1 b=E1ze: 262 - datum vyd=E1n=ED: 17.3.2003