pilot-db-list

[pilot-db-list] Hide a row ?

[Mr C. R G. <ori...@ya...>]

Thanks to suggestions from Andre & Yedidyah, I was able to produce a 'checkbox' row using the 'Boolean' option and a global setting.

One last question on this topic....once a row has been checked, is it possible to toggle that row to 'disappear' from the display? Then, uncheck the row and it becomes 'visible' once again?

Thank you again.


		
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.

[pilot-db-list] Re: Pilot-db-list digest, Vol 1 #912 - 1 msg

[Kyle D. <dav...@ya...>]

--- pil...@li... wrote:
> 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. Checkbox ? (Mr Cuyler R Griffith)
> 
> --__--__--
> 
> Message: 1
> Date: Sat, 24 Jul 2004 19:15:08 -0700 (PDT)
> From: Mr Cuyler R Griffith <ori...@ya...>
> To: Pilot-DB List
> <pil...@li...>
> Subject: [pilot-db-list] Checkbox ?
> 
> --0-1788247265-1090721708=:69204
> Content-Type: text/plain; charset=us-ascii
> 
> I've looked all thru the manual but cannot find the
> 'format type' to use a checkbox. 
>  
> I just want to create a simple list in database form
> that has checkboxes that I can check off as I
> progress thru the list.
>  
> Appreciate some assistance.
>  
> Best,
> Cuyler
> 
> 		
> ---------------------------------
> Do you Yahoo!?
> New and Improved Yahoo! Mail - 100MB free storage!
> --0-1788247265-1090721708=:69204
> Content-Type: text/html; charset=us-ascii
> 
> <DIV><FONT face="comic sans ms">I've looked all thru
> the manual but cannot find the 'format type' to use
> a checkbox.&nbsp;</FONT></DIV>
> <DIV><FONT face="comic sans ms"></FONT>&nbsp;</DIV>
> <DIV><FONT face="comic sans ms">I just want to
> create a simple list in database form that has
> checkboxes that I can check off as I progress thru
> the list.</FONT></DIV>
> <DIV><FONT face="Comic Sans MS"></FONT>&nbsp;</DIV>
> <DIV><FONT face="Comic Sans MS">Appreciate some
> assistance.</FONT></DIV>
> <DIV><FONT face="Comic Sans MS"></FONT>&nbsp;</DIV>
> <DIV><FONT face="Comic Sans MS">Best,</FONT></DIV>
> <DIV><FONT face="Comic Sans
> MS">Cuyler</FONT></DIV><p>
> 		<hr size=1>Do you Yahoo!?<br>
> <a
>
href="http://us.rd.yahoo.com/mail_us/taglines/100/*http://promotions.yahoo.com/new_mail/static/efficiency.html">New
> and Improved Yahoo! Mail</a> - 100MB free storage!
> --0-1788247265-1090721708=:69204--
> 
> 
> 
> --__--__--
> 
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
>
https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 
> 
> End of Pilot-db-list Digest
> 

I believe the BOOLEAN field type may be what you're
looking for.

Cheers,

Kyle


		
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now. 
http://messenger.yahoo.com

Re: [pilot-db-list] Checkbox ?

[Andre K. <and...@gm...>]

On Sun, Jul 25, 2004 at 07:05:15AM -0700, Mr Cuyler R Griffith wrote:
> Yes, I did see that option but so far, when I tap the checkbox, I'm only taken in to the record form.  I was hoping to see a checkmark appear in the checkbox.
>  
> Not possible ?

You have to activate Options -> Global preferences -> Open databases Read/Write.
Then you can toggle the checkbox directly in the table.

Btw, would be nice to have a per database option "Open database Read/Write",
rather than a global setting.

-- 
     _   _
_/\_| |_( )_
Andre Kuehne

Re: [pilot-db-list] Checkbox ?

[Mr C. R G. <ori...@ya...>]

Yes, I did see that option but so far, when I tap the checkbox, I'm only taken in to the record form.  I was hoping to see a checkmark appear in the checkbox.
 
Not possible ?
 
 
 


Yedidyah Bar-David <di...@ta...> wrote:On Sat, Jul 24, 2004 at 07:15:08PM -0700, Mr Cuyler R Griffith wrote:
> I've looked all thru the manual but cannot find the 'format type' to use a checkbox. 
> 
> I just want to create a simple list in database form that has checkboxes that I can check off as I progress thru the list.

It's called "boolean".
-- 
Didi



		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!

[pilot-db-list] RE:Pilot-db-list digest, Vol 1 #912 - 1 msg

[<jb....@wa...>]

To make a checkbox, you make a field type boolean.
Regards 

Jean Bernard
jb....@wa...
http://perso.wanadoo.fr/jean-bernard.conte/
Envoy=E9 =E0 partir de mon communicateur Treo

-----Message d'origine-----
De:pil...@li...
Date:25/7/04 5:34
A:  pil...@li...
Obj.:  Pilot-db-list digest, Vol 1 #912 - 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. Checkbox ? (Mr Cuyler R Griffith)

--__--__--

Message: 1
Date: Sat, 24 Jul 2004 19:15:08 -0700 (PDT)
From: Mr Cuyler R Griffith <ori...@ya...>
To: Pilot-DB List <pil...@li...>
Subject: [pilot-db-list] Checkbox ?

--0-1788247265-1090721708=3D:69204
Content-Type: text/plain; charset=3Dus-ascii

I've looked all thru the manual but cannot find the 'format type' to use=
 a checkbox. 
 
I just want to create a simple list in database form that has checkboxes=
 that I can check off as I progress thru the list.
 
Appreciate some assistance.
 
Best,
Cuyler

		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
--0-1788247265-1090721708=3D:69204
Content-Type: text/html; charset=3Dus-ascii

<DIV><FONT face=3D"comic sans ms">I've looked all thru the manual but =
cannot find the 'format type' to use a checkbox.&nbsp;</FONT></DIV>
<DIV><FONT face=3D"comic sans ms"></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"comic sans ms">I just want to create a simple list in=
 database form that has checkboxes that I can check off as I progress thru=
 the list.</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS"></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">Appreciate some assistance.</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS"></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">Best,</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS">Cuyler</FONT></DIV><p>
		<hr size=3D1>Do you Yahoo!?<br>
<a =
href=3D"http://us.rd.yahoo.com/mail_us/taglines/100/*http://promotions.yah=
hoo.com/new_mail/static/efficiency.html">New and Improved Yahoo! Mail</a>=
 - 100MB free storage!
--0-1788247265-1090721708=3D:69204--



--__--__--

_______________________________________________
Pilot-db-list mailing list
Pil...@li...
https://lists.sourceforge.net/lists/listinfo/pilot-db-list


End of Pilot-db-list Digest

Re: [pilot-db-list] Checkbox ?

[Yedidyah Bar-D. <di...@ta...>]

On Sat, Jul 24, 2004 at 07:15:08PM -0700, Mr Cuyler R Griffith wrote:
> I've looked all thru the manual but cannot find the 'format type' to use a checkbox. 
>  
> I just want to create a simple list in database form that has checkboxes that I can check off as I progress thru the list.

It's called "boolean".
-- 
Didi

[pilot-db-list] Checkbox ?

[Mr C. R G. <ori...@ya...>]

I've looked all thru the manual but cannot find the 'format type' to use a checkbox. 
 
I just want to create a simple list in database form that has checkboxes that I can check off as I progress thru the list.
 
Appreciate some assistance.
 
Best,
Cuyler

		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!

[pilot-db-list] SQLite backend for db

[Michael B. <bro...@ya...>]

Hi Folks!

Just wondering if anyone has given some thought to
using SQLite (http://www.sqlite.org )for a backend for
Pilot-db.  It's an open source sql based project. 
Someone has already ported an older version of SQLite
to Palm OS.  There's been some interest in porting it
to Palm OS6/ARM native in the sqlite mailing list
(archives at gmane).

Some info on SQLitePalm can be found here
http://www.sqlite.org/cvstrac/wiki?p=SqlitePalm

Have a good one!

/Mike

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca

[pilot-db-list] Monthly running total

[<cl...@is...>]

Hello:
     Is there a script that can compute a running total that "breaks" on the=
 month?  An example would be:
  <DATE>     <AMOUNT>     <RUN_TOTL>
 7/19/04       2=2E00         2=2E00
 7/21/04       3=2E00         5=2E00
 8/21/04       8=2E00         8=2E00

I managed to do this by adding an extra integer field and entering the month=
, but there must be a better way=2E Thanking all in advance=2E =20

Re: [pilot-db-list] Plug-in questions

[Heinz D. <Dr...@gm...>]

>>  1) On an assortment of MobileDB databases, Pilot-DB pops up an
"Experimental
>> Large Database Support" screen.  The only thing I can do is tap the Home
>> icon to exit Pilot-DB and open it again.  It didn"t do this on my old
Visor
>> Pro.  Is there a way to turn that off?

> The first question: Someone checked in code with that alert.  I"ve done 
> a build without it and will send it to you off-list.

Please sent me the version without that alert too. Or where can I download
it?

Heinz

[pilot-db-list] Global preferences - Fatal Alert V1.2

[Heinz D. <Dr...@gm...>]

Global preferences - Fatal Alert
I use 1.1.0, but allways the vldb-message appear, so I
install 1.2.

Now the error-message

Fatal Alert
Emul68KCommon.c, Line:1594, Index out of range
Reset

appear when I click on "global preferences" in the
Option-menu.

I habe a Tungsten E with no extra-memory. The DB has
4000 entries.

Re: [pilot-db-list] Import data in dbase with calculated fields

[Yedidyah Bar-D. <di...@ta...>]

On Fri, Jul 09, 2004 at 05:38:19PM +0200, ft...@li... wrote:
> Hi,
> 
> I created the database file with palm (db 1.1), I set up all the fields.
> Some of them are "calculated" type.
> I've in the desktop (Windows XP) some data (excel, csv and so on).
> 
> The query is that I would like to import the data into the dbase in my palm, and obviuosly I would like that calculated field will work and being correctly fill in.
> 
> In Dbeditor (v 0.7.4.0) using import it create a new pdb file, by the way dbeditor do not support calculated fields, also paste and copy do not work.
> 
> Periodically I need to import data in the pdb file..... so import with db and after to create calculated fields (4 and a little complicated it is not easy).

Exporting calculated fields is known to not work well. I don't know why
yet, but it's probably not very hard to fix. Exporting and Importing the
scripts is much more work. I do now know of a problem to import them, in
the following meaning: Suppose you have a table with one data field f1
and one calculated field c1. You enter some lines of data into f1 and c1
is calculated. Now you export the db to a csv/inf, add some more lines
in your PC, and import it back. Sadly, as I said before, the export you
did before did not export the scripts, and obviously the import dropped
them. But there is a workaround: There is a program called par (hit 4 in
google) that can take out the appInfo part from the pdb. So you can try
to do the following: keep the appInfo of the original pdb, then do what
you want (pdb2csv, edit, csv2pdb), then take the data (with par) from
the new one, and the appInfo from the original. Not everything will work
well - e.g. if you have integer fields with autoincrement they won't
work well. But you can try playing with this.

I had intentions to make a new tool that will export/import everything,
but did not progress much. Maybe in a few weeks I will have time again
to work on this.

> 
> By the way... this is my first query in this mailing list, so .... hi to everybody.

Hi :-)
-- 
Didi

Re: [pilot-db-list] Experimental Very Large Database Support

[Yedidyah Bar-D. <di...@ta...>]

Hi,

On Fri, Jul 09, 2004 at 02:30:59PM +0200, Fel...@t-... wrote:
> Hello,
> 
> with version 1.1 I get the debug information window on a Tungsten T3
> when trying to open a database with 3000 records (it can be openend
> using version 1.0.3). The window says: "Experimental Very Large Database
> Support". When I duplicate the database and open the new built one I get
> the same window.
> 
> Is there anything I can get rid off this message? Cause in the older
> version it works fine.

You can do one of two things: Either compile it without vldb or
comment out the message. It's not (yet?) clear to me how stable this
vldb is, so I can't say which is better. Do you find it faster than
the older version?
-- 
Didi

[pilot-db-list] Import data in dbase with calculated fields

[ftozzi\@libero\.it <ft...@li...>]

Hi,

I created the database file with palm (db 1.1), I set up all the f=
ields.
Some of them are "calculated" type.
I've in the desktop (Windows=
 XP) some data (excel, csv and so on).

The query is that I would like =
to import the data into the dbase in my palm, and obviuosly I would like =
that calculated field will work and being correctly fill in.

In Dbedit=
or (v 0.7.4.0) using import it create a new pdb file, by the way dbeditor=
 do not support calculated fields, also paste and copy do not work.

Pe=
riodically I need to import data in the pdb file..... so import with db a=
nd after to create calculated fields (4 and a little complicated it is no=
t easy).

By the way... this is my first query in this mailing list, so=
 .... hi to everybody.



My best
Fabri

[pilot-db-list] Experimental Very Large Database Support

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

Hello,

with version 1.1 I get the debug information window on a Tungsten T3
when trying to open a database with 3000 records (it can be openend
using version 1.0.3). The window says: "Experimental Very Large Database
Support". When I duplicate the database and open the new built one I get
the same window.

Is there anything I can get rid off this message? Cause in the older
version it works fine.

kr

Jürgen "Felix" Lanzendorfer

Re: [pilot-db-list] Scroll Bar for Pilot DB

[<Cyb...@ao...>]

I am over 900+ movies right now when I hit a flat 1000 I am going to copy  my 
db's and everything and get them on a site somewhere for people to test the  
limits of pilot db. Should be interesting none the less. 
 
John
 

[pilot-db-list] temporary mailing list admin?

[Nathan K. <na...@ve...>]

Hello --

I'm leaving tomorrow night on a trip to China and will be gone about a
month.  If anyone would be available to do a little temporary mailing
list administration, it would help things keep going.

The job is really simple:  every couple days, check the posts that
have been submitted from non-members.  Delete the spam, approve the
rest.  It takes about an hour a week.  

We could just let it slide, but then folks like Marc (inexplicably not
subscribed) will have their posts just sit there instead of being sent
to the list.  Of course, I suppose Marc could just subscribe :).

If anyone is interested, drop me a private email soon and I'll tell
you the specifics.  I suppose, for that matter, if anyone has suggestions 
for Hong Kong/Guangzhou/Shanghai/Chengdu send them along too... :)

Nathan Kurz
na...@ve...

Re: [pilot-db-list] Scroll Bar for Pilot DB

[Mark W. <mar...@fr...>]

If you write a Graffiti letter (I assume this works for thumb-boards)=20
then you will be taken to the first record in your database starting=20
with the letter or number.  This is much faster than scrolling or=20
paging down, unless of course you have a list of 1500 movies all=20
beginning "The".  Obviously it helps to do a sort on the field first.

Enjoy

Mark Walker
On 21 Jun 2004, at 06:48, DH wrote:

> Great program,
> =A0
> Thank you for your hard work.
> =A0
> One feature I would love to see is a scroll bar which would allow us=20=

> to scroll throught our records, I have 1500 names in my database and=20=

> scrolling to a name would be a lot easier than using the find option.
> =A0
> Dan
>
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!=

Re: [pilot-db-list] Scroll Bar for Pilot DB

[Yedidyah Bar-D. <di...@ta...>]

On Sun, Jun 20, 2004 at 10:48:37PM -0700, DH wrote:
> Great program,
>  
> Thank you for your hard work.
>  
> One feature I would love to see is a scroll bar which would allow us to scroll throught our records, I have 1500 names in my database and scrolling to a name would be a lot easier than using the find option.

I agree it can be useful, but I am not sure it would be much faster than
using pgup/pgdn keys, which move a page (10 records) by default. It takes
only a few seconds to scroll through a 1000 records db with them (tried).
I also have no idea how much work it would be to implement this.
I suggest that you try to create some useful filters on your data - I
can't imagine you use the entire set of 1500 records uniformly, without
any filterable behaviour. I have a patch pending to make the filter
selection window much bigger, to allow easier selection.
-- 
Didi

Re: [pilot-db-list] csv2pdb converter

[Yedidyah Bar-D. <di...@ta...>]

On Mon, Jun 21, 2004 at 03:02:07PM -0400, Alex Mendy wrote:
> Hi,
> 
>  
> 
> Just wondering how/where do you specify CreatorID for newly created PDB
> file?

If you refer to the csv2pdb from palm-db-tools (the only one I know
about), then it creates only pilot-db pdb files, and puts there the
creatorid of pilot-db. If you are looking for more general tools for
pdb files, you can look at par (as well as more common things like
pilot-link etc.).
-- 
Didi

Re: [pilot-db-list] csv2pdb converter

[Marc C. <mar...@la...>]

Alex Mendy wrote:

>I thought that CreatorID is a relative ID-string that you specify when
>creating PDB of a certain type.  If that is so, why is it not possible to
>specify your own CreatorID ?
>
because the database format depend to the application which uses it, and 
an application knows the databases to use with the CreatorID. csv2pdb 
creates databases for Pilot-DB (and for JFile and MobileDB), if you 
change the CreatorID your database is useless with Pilot-DB.

>Thanks.
>
>-----Original Message-----
>From: marc-chalain [mailto:mar...@la...] 
>Sent: Friday, June 25, 2004 4:38 AM
>To: alexm.ajv
>Cc: pilot-db-list
>Subject: Re:[pilot-db-list] csv2pdb converter
>
>It's impossible, the CreatorID depend to the Database type.
>
>  
>
>>Hi,
>>
>>    
>>
>
>  
>
>> 
>>
>>Just wondering how/where do you specify CreatorID for newly
>>    
>>
>
>created PDB
>  
>
>>file?
>>
>> 
>>
>>Thanks.
>>
>>    
>>

Re:[pilot-db-list] Scroll Bar for Pilot DB

[marc-chalain <mar...@la...>]

We have implementd a lot of possibility to move in the database:
 - the =
find option is one.
 - the quick find (you enter a letter and you will g=
o to the
first record which begin with this letter.
 - the scroll butto=
ns on the right bottom that you can
configure to move line by line or pa=
ge by page.
 - the hard key to supply the scroll buttons.
 - the roll f=
or the Clie and Handera (and perhaps the treo)

I think it's useless to=
 add a new one.

> Great program,
>  
> Thank you for your hard work.=

>  
> One feature I would love to see is a scroll bar which would
all=
ow us to scroll throught our records, I have 1500 names in
my database a=
nd scrolling to a name would be a lot easier than
using the find option.=

>  
> Dan
> 
> 		
> ---------------------------------
> Do you Yah=
oo!?
> Yahoo! Mail - 50x more storage than other providers!=0A=0AAcc=E9d=
ez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3615 LAP=
OSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)=0A=0A

Re:[pilot-db-list] csv2pdb converter

[marc-chalain <mar...@la...>]

It's impossible, the CreatorID depend to the Database type.

> Hi,
> =0D
=
>  
> 
> Just wondering how/where do you specify CreatorID for newly=0D
=
created PDB
> file?
> 
>  
> 
> Thanks.
> 
>  
> 
> =0A=0AAcc=E9=
dez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3615 LA=
POSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)=0A=0A

[pilot-db-list] csv2pdb converter

[Alex M. <ale...@ea...>]

Hi,

 

Just wondering how/where do you specify CreatorID for newly created PDB
file?

 

Thanks.

 

[pilot-db-list] Scroll Bar for Pilot DB

[DH <swa...@ya...>]

Great program,
 
Thank you for your hard work.
 
One feature I would love to see is a scroll bar which would allow us to scroll throught our records, I have 1500 names in my database and scrolling to a name would be a lot easier than using the find option.
 
Dan

		
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!