pilot-db-list

[pilot-db-list] db is great

[<Mar...@si...>]

Thanks to everyone for all your help in making db so great.

Here is a user's report:

1. You can't filter on a checkbox (boolean) field, since the
ConvertFieldToString() function doesn't create a corresponding string value
for a boolean for you to compare against in the filter.

2. Any chance of being able to attach a note to a database. Then database
creators can add copying information or meta descriptions of the schema or
help, etc. for their databases? If you wanted to get really carried away,
then adding a note per field in the design would be useful too, for field
descriptions (explains to users what to put in each field, etc.) But a note
per database would be sufficient.

3. Any chance of making the loading of a new database (rather than an
update) faster. I am assuming the current approach is to create the
database and then add the records in over the link. This is rather slow for
large databases, when "all you need do" :) is grab the .pdb and sort it out
later. It also seems to fall over for read only databases.

4. It would be nice to have an option to turn on auto-title case for text
fields (per field is best, per database is next best :) Like what memo does
after a fullstop space.

Thanks again for such a great program. I keep giving it to my friends and
is probably the one killer app for a Palm, at least for me.

Martin Hosken

PS. Please reply direct as well as to the list, since I am not on the list.
Ta

AW: [pilot-db-list] corrupted file?

[Kaldewey M. <Mal...@pd...>]

The only thing I would try, is to copy the file on your PC and use the =
db
tools to convert it to a csv file.

> -----Urspr=FCngliche Nachricht-----
> Von: Paul Bliss [mailto:pb...@ks...]
> Gesendet am: Mittwoch, 19. Dezember 2001 23:17
> An: pil...@li...
> Betreff: [pilot-db-list] corrupted file?
>=20
> is there any method to recover the data in a DB file that=20
> will not open? I
> get an error dialog "Unable to open database."
>=20
>=20
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>=20

[pilot-db-list] help, new to palm os and db

[<pas...@sn...>]

I just installed the DB.3.3c on my HS Platinum , at the moment I have
one database  which will consist of a maximum of 900 standby power
supplieshow do I get this db onto the desktop app.? I have backup on
hotsync checked, but I'm missing something  because I don't see the db
saved  in the palm desk top.
I'm a complete newbie to this stuff , also do I have to export this to
a spreed sheet program or can I just print out what I need once I get
it into the desk top ?

Sorry for a beginners question.

PJFSr.

[pilot-db-list] corrupted file?

[Paul B. <pb...@ks...>]

is there any method to recover the data in a DB file that will not open? I
get an error dialog "Unable to open database."

Re: [pilot-db-list] Questions about List type

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

Perhaps the best thing to do is to not use the list type - or at least not
sort on it.

Instead, create a numeric field at the end of the record that indicates a
sequence number.

I have a similar need - I have databases of gaming cards (think Magic
the gathering, etc.) .  There are multiple groupings of cards in one database
- within each grouping there are numeric sequences.  I'd love to be able
to sort by various fields, then tell DB to return to an original 
order not based on sorting.
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
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.
-><-

AW: [pilot-db-list] Questions about List type

[Kaldewey M. <Mal...@pd...>]

I've got the same problem. I resolved it with a db LINK field. At first =
I
create some externel db's with the values I need. There, I can sort the
values. After that, I assign these new db's a category, so they don't
disturb in the start view.
It's not the best idea, but it works fine.

With best greetings
Malte

> -----Urspr=FCngliche Nachricht-----
> Von: Anne Judge [mailto:ann...@al...]
> Gesendet am: Dienstag, 18. Dezember 2001 23:47
> An: Pil...@li...
> Betreff: Re: [pilot-db-list] Questions about List type
>=20
> Ah, so if I understand this correctly, with 0.3.3 new list items can
> be added, but only to the end of the list, and existing items=20
> can't be rearranged
>=20
> In 0.3.4, additional items can be added anywhere in the list, but =
once
> there can't be rearranged.
>=20
> I can live with that, or alternatively with alphabetical sorting -
> either is OK, my only real PROBLEM (the others were just questions so
> I'd know where things stood) is that I get pretty funky (illogical)
> sorting when I sort on a list field, since it comes out in the order
> items were added to the list! =20
>=20
> (Just to motivate my questions, my immediate use is for a
> books-to-read database, so if I sorted by author it would end up in
> the order I had learned that that author's works might be interesting
> & added him/her to the list, not by the author's name =
[alphabetically]
> or my choice of where that author should fall [list order]).
>=20
> I realize that this isn't commercial software with a paid development
> team, and it's pretty amazing the level of commitment it's getting! =20
>=20
> Anne
>=20
> Chalain Marc wrote:
> >=20
> > Anne Judge wrote:
> >=20
> > > - As far as I can see, there's no way to change the order=20
> of a list
> > > once it's created - I see how to add or delete items, but=20
> added items
> > > go to the end of the list.  So items are in the list in the order
> > > they're put in, not the order in which I want them.  And=20
> I can't see
> > > how to move existing items around in the list.  Am I=20
> missing something?
> >=20
> > Yes you missed something. When you are in the database=20
> structure on the left of each field there is an arrow. When=20
> you hit it a list box appear with the "properties" menu.=20
> Select it and you will see the "properties box" with the=20
> access of the list items. In the next version when you select=20
> an item and hit the new button, the new item will be added=20
> just before the current item selected.
>=20
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>=20

Re: [pilot-db-list] Questions about List type

[Anne J. <ann...@al...>]

Ah, so if I understand this correctly, with 0.3.3 new list items can
be added, but only to the end of the list, and existing items can't be rearranged

In 0.3.4, additional items can be added anywhere in the list, but once
there can't be rearranged.

I can live with that, or alternatively with alphabetical sorting -
either is OK, my only real PROBLEM (the others were just questions so
I'd know where things stood) is that I get pretty funky (illogical)
sorting when I sort on a list field, since it comes out in the order
items were added to the list!  

(Just to motivate my questions, my immediate use is for a
books-to-read database, so if I sorted by author it would end up in
the order I had learned that that author's works might be interesting
& added him/her to the list, not by the author's name [alphabetically]
or my choice of where that author should fall [list order]).

I realize that this isn't commercial software with a paid development
team, and it's pretty amazing the level of commitment it's getting!  

Anne

Chalain Marc wrote:
> 
> Anne Judge wrote:
> 
> > - As far as I can see, there's no way to change the order of a list
> > once it's created - I see how to add or delete items, but added items
> > go to the end of the list.  So items are in the list in the order
> > they're put in, not the order in which I want them.  And I can't see
> > how to move existing items around in the list.  Am I missing something?
> 
> Yes you missed something. When you are in the database structure on the left of each field there is an arrow. When you hit it a list box appear with the "properties" menu. Select it and you will see the "properties box" with the access of the list items. In the next version when you select an item and hit the new button, the new item will be added just before the current item selected.

Re:[pilot-db-list] feature request

[Chalain Marc<mar...@vo...>]

> Some requests:
> 1-vertical scroll bar, to scroll rapidly throught records
not yet but i thought about that
> 2-ability to manage large databases (I tried a 10000+
> records dictionary in Jfile 3 format: it is impossible to
> search records in it).
i don't know the limites od DB.
> 3-global prefs regarding colors (gray levels aren't
> readable on IIIxe screen)
Can you send me your ROM please? I will create a plugin to select the colors in a close future.
> 4-direct DB import/export for Macintosh
I'm looking for sombody to build the Palm-DB-Tools for Mac. Do you want to do that.
> 5-on board API to interface it with OnBoardC
I don't know.


____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

Re:[pilot-db-list] Questions about List type

[Chalain Marc<mar...@vo...>]

Anne Judge wrote:

> My apologies if I've missed the answers to these somewhere . . .
> 
> I just downloaded DB 0.3.3 and now that it has the list type - YAY!!!
> - I'm just about ready to dump JFile demo and be able to use more than
> one database (the limitation of JFile's demo).
> 
> But I've run into some questions about list behavior:
> 
> (And please, let me know if there's some place this has been
> documented that I missed, so I don't have to bother the whole list
> about it!)
> 
> - When I sort on that field, it sorts in the order of the list, rather
> than alphabetically.  Is this planned?  Actually, this would be great,
> except for as indicated by my next question:

No, i can add a choice between alphabetical and others sorts.

> - As far as I can see, there's no way to change the order of a list
> once it's created - I see how to add or delete items, but added items
> go to the end of the list.  So items are in the list in the order
> they're put in, not the order in which I want them.  And I can't see
> how to move existing items around in the list.  Am I missing something?

Yes you missed something. When you are in the database structure on the left of each field there is an arrow. When you hit it a list box appear with the "properties" menu. Select it and you will see the "properties box" with the access of the list items. In the next version when you select an item and hit the new button, the new item will be added just before the current item selected.

> 
> (Thanks to the previous post here on how to add/delete items to an
> existing list - I couldn't figure that out without those instructions.)
> 
> - Similarly, is there a way to change an item in the list (e.g. change
> list item "Ann" to "Anne"), without deleting the old entry and adding
> the new one (in which case, all the records with that item change to
> "N/A" and you have to go modifying each one again).

That will be impossible, you must delete the item and create another

> I realize that List type is in its infancy in DB, and there are bound
> to be things to work out - just want to know if these have already
> been thought of/taken care of, or will/might be in future versions!  

DB is a free software and our intention is to give the more features as it's possible, but it's difficult to answer to every requests.

> And THANKS for adding the list type, which esp. with the limits of
> Graffiti makes this SO MUCH more usable.  
> 
> (And BTW, I'm using a "hand-me-down" Palm Pilot Pro so the Palm OS 2
> compatibility is greatly appreciated.)

Thank, i had a PalmPilot and i understand you.

Salut,
Marc.
____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] Questions about List type

[Anne J. <ann...@al...>]

My apologies if I've missed the answers to these somewhere . . .

I just downloaded DB 0.3.3 and now that it has the list type - YAY!!!
- I'm just about ready to dump JFile demo and be able to use more than
one database (the limitation of JFile's demo).

But I've run into some questions about list behavior:

(And please, let me know if there's some place this has been
documented that I missed, so I don't have to bother the whole list
about it!)

- When I sort on that field, it sorts in the order of the list, rather
than alphabetically.  Is this planned?  Actually, this would be great,
except for as indicated by my next question:

- As far as I can see, there's no way to change the order of a list
once it's created - I see how to add or delete items, but added items
go to the end of the list.  So items are in the list in the order
they're put in, not the order in which I want them.  And I can't see
how to move existing items around in the list.  Am I missing something?

(Thanks to the previous post here on how to add/delete items to an
existing list - I couldn't figure that out without those instructions.)

- Similarly, is there a way to change an item in the list (e.g. change
list item "Ann" to "Anne"), without deleting the old entry and adding
the new one (in which case, all the records with that item change to
"N/A" and you have to go modifying each one again).

I realize that List type is in its infancy in DB, and there are bound
to be things to work out - just want to know if these have already
been thought of/taken care of, or will/might be in future versions!  

And THANKS for adding the list type, which esp. with the limits of
Graffiti makes this SO MUCH more usable.  

(And BTW, I'm using a "hand-me-down" Palm Pilot Pro so the Palm OS 2
compatibility is greatly appreciated.)

Anne

[pilot-db-list] Some new databases

[Kaldewey M. <Mal...@pd...>]

Hello,
I've created some databases with db 0.3.3. If someone is interested, they
can be downloaded by the following url:

http://pdassi.de/searchext.php?what=software&str=Malte+Kaldewey

Please feel free, to update the structure of these db's. You'll be welcome
to make some proposals and send me some feedback. 

With best regards
Malte

[pilot-db-list] missing data followup

[Carson W. <car...@fi...>]

I've found that if I go into a database and do a search, then go back to no filter the data is there. Howerver once I leave the database and go back into it, I can no longer see any data until after another search.

Thanks,
Carson


Carson R. Wilcox
Senior Consultant
DMR Consulting
Tampa, FL USA

_____________________________________________________________
Want a new web-based email account ? ---> http://www.firstlinux.net

[pilot-db-list] feature request

[<ale...@ya...>]

Some requests:
1-vertical scroll bar, to scroll rapidly throught records
2-ability to manage large databases (I tried a 10000+
records dictionary in Jfile 3 format: it is impossible to
search records in it).
3-global prefs regarding colors (gray levels aren't
readable on IIIxe screen)
4-direct DB import/export for Macintosh
5-on board API to interface it with OnBoardC

Thanks - merci - milesker!
Alexandre

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Courrier : http://courrier.yahoo.fr

[pilot-db-list] missing data, 0.3.4alpha

[Carson W. <car...@fi...>]

I hope this is an optical illusion. I don't seem to see any data in any of my databases. I'm sure it was there over the weekend but it's gone this morning. I really hope someone can help me with this because I need it today and won't be able to recover from backups till later tonight.

Thanks,
Carson

Carson R. Wilcox
Senior Consultant
DMR Consulting
Tampa, FL USA

_____________________________________________________________
Want a new web-based email account ? ---> http://www.firstlinux.net

[pilot-db-list] Setting Filter?

[Kaldewey M. <Mal...@pd...>]

How can I set Filter? I'm only see the drop- down field at the bottom of
each database.

With best regards
Malte

Re: AW: [pilot-db-list] Pilot-DB Web-Site News Ticker

[Chalain Marc<mar...@vo...>]

I don't understand there is nothing new on the website for me? I have Netscape 4.5.
Salut,
Marc.



____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] Pilot-DB WebSite News

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

Hi!

Due to incompatibility with Netscape and Opera
I have removed the News-Ticker from the main
page and placed it into the status bar.

This seems to be a more inconspicuous and subtle
solution.

Comments?

Hans

Re: AW: [pilot-db-list] Pilot-DB Web-Site News Ticker

[Oliver G. <oli...@we...>]

Hi Hans!

Hans Ajiet Holtkamp wrote:

> 
> I noticed the problem this morning.
> 
> I have a solution that will work on all
> browsers, but without links.
> 
> The problem is that you can address ID's of
> <div> <span> or <p> tags in ie using
> 
> ID.innerHTML = "Text" or
> ID.innerText = "Text"
> 
> but this does not work with NS or Opera, although it
> is HTML 4 standard! However, it is not incorrect programming.
> 

I'm not so sure about this being part of the HTML specification.
I always was under the impression that the scripting languages
themselves are proprietary extensions by specific companies.
JavaScript was AFAIK invented and first implemented by Netscape,
Microsoft implemented their own version of JavaScript with a
few additions and alterations and they also came up with
VBScript (which nobody understands outside the Windows world).

I just had a quick look at the HTML 4.01 specification over at
w3c.org and the only thing I found regarding scripting was
a definition about the way an (input) event is mapped to
a script. There were several examples in JavaScript, VBScript,
and Tcl.

But the HTML specification does not define the syntax or
capabilities of the scripting language itself.

In <http://www.w3.org/TR/html4/interact/scripts.html#h-18.2.2.3>
I found the following:
"Each scripting language has its own conventions for referring to HTML
objects from within a script. This specification does not define a
standard mechanism for referring to HTML objects."

> A Form input tag can be addressed in ie and NS using
> 
> document.form1.scrollField.value = "Text";
> 
> but cannot contain links.
> 
> If you have any other solutions, please let me know.
> 

I'm afraid I can't be of much help here at the moment, since
I haven't really done much with JavaScript since the
aforementioned "painful expieriences" ;-), but I'll
see if I can play around a bit with it when I find the
time (certainly not before Sunday, I'm afraid).

Regards,

	Oliver



-- 
Oliver Goetz, mailto:oli...@we...
    "I'd rather laugh with the sinners than cry with the saints
     Sinners are much more fun...   And only the good die young"
                                                      -- Billy Joel

Re: [pilot-db-list] Pilot-DB Web-Site News Ticker

[Oliver G. <oli...@we...>]

Hi Hans!

Hans Ajiet Holtkamp wrote:

 > In case anyone is interested, I've just added
 > a Javascript Newsticker to the Web-Site:
 >
 > http://pilot-db.sourceforge.net/
 >
 > Any comments?
 >

I'm not really sure what to think of it. I mean, I don't
expect to see any daily news there, maybe a static page
with news would be better (I'd have all the information
in one go and wouldn't have to wait until something is
shown in the newsticker.)

Besides, the javascript code seems to be either faulty
or uses proprietary code that only works in Internet
Explorer (which is in my view pretty much the same thing).

I tried it with Netscape 4.7 & 6.2 as well as with Opera 6.0
and it doesn't work in any of these browsers.

Netscape 6.2 shows the following error messages when I type
"javascript:" in the location field:

Error: aimRDFDataSource() has no properties
Source File: chrome://aim/content/aimHdrViewOverlay.js
Line: 136

Error: mtxt is not defined
Source File: http://pilot-db.sourceforge.net/main.htm
Line: 54

Error: redeclaration of const kIOServiceProgID
Source File: chrome://communicator/content/utilityOverlay.js
Line: 1

Maybe they are of some use to you. I know from painful
expierience that making Javascript work in more than one
browser can be a very tricky thing. But if it doesn't work
everywhere, it's not of much use, IMHO.

I hope my views on this don't come across too harsh. I do
appreciate very much the work and creativity you put into
the web site. I just think that this newsticker my be a
bit more work than it's woth.

Regards,
	Oliver


-- 
Oliver Goetz, mailto:oli...@we...
     "I'd rather laugh with the sinners than cry with the saints
      Sinners are much more fun...   And only the good die young"
                                                       -- Billy Joel

Re:[pilot-db-list] Unique Key?

[Chalain Marc<mar...@vo...>]

No, but the future version is able to put a default value for an integer and an icrement value that will be added to the default value. If you give, for an ID integer, the value 0 to the default value and 1 to the increment each time that you create a new record or duplicate an older, your ID will be incremented. You will be able to modify the last default value.
Salut,
Marc.

PS: very soon a snapshot version of the 0.3.4.



> Does the db 0.3.3 have something like a uniqui key? I need some fields with
> an unique key.
> 
> With best regards
> Malte

____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] Unique Key?

[Kaldewey M. <Mal...@pd...>]

Does the db 0.3.3 have something like a uniqui key? I need some fields with
an unique key.

With best regards
Malte

[pilot-db-list] Pilot-DB Web-Site News Ticker

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

In case anyone is interested, I've just added
a Javascript Newsticker to the Web-Site:

http://pilot-db.sourceforge.net/

Any comments?

Hans

Re:[pilot-db-list] Search in Boolean Fields

[Chalain Marc<mar...@vo...>]

No this version doesn't correct the bug on Boolean, sorry.
I corrected it for the next version and it will be "1" or "0"

For the graffiti indicator i will try to integrate it, but not on the Handera version (i have some trouble to move it when the screen size change).
Salut,
Marc.

> Hello,
> I'm using DB 0.3.3c from 03 Dec 2001. What i whould
> like to know is, does this Version fix the find in
> Boolean field error. If yes, I seem to have missed
> the syntax. I have tried 0 or 1 and true or false.
> What would the correct syntax.
> 
> Further i have a feature request.
> Since I use Fields with entries in CAPS i need to
> switch to caps lock on data entry. In DB i can not
> see in which mode i am. Other Application show a
> symbol in the lower right of the screen to indicate
> edit mode. Here it would somewhere to the right of
> the buttons.
> 
> with kind regards
> 
> Klaus Leiss

____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] Search in Boolean Fields

[Leiss, Klaus-G. 3. S-PP-RD-E. <Kla...@de...>]

Hello,
I'm using DB 0.3.3c from 03 Dec 2001. What i whould
like to know is, does this Version fix the find in
Boolean field error. If yes, I seem to have missed
the syntax. I have tried 0 or 1 and true or false.
What would the correct syntax.

Further i have a feature request.
Since I use Fields with entries in CAPS i need to
switch to caps lock on data entry. In DB i can not
see in which mode i am. Other Application show a
symbol in the lower right of the screen to indicate
edit mode. Here it would somewhere to the right of
the buttons.

with kind regards

Klaus Leiss

[pilot-db-list] Re: Field Types: Calculated

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

Mark,

	the scripts underwent a major rewrite between 0.3.3 alpha, and
the current working version.  They are now in testing and we expect 
them to be released soon.  They have the ability to calculate values based 
on the contents of a single record, or a small group of records, but 
currently you cannot add up the contents of an entire column of data.  
That will have to wait for a bit.

	-Scott


 Greetings,

I would like to put your database to personal use but I need the calculated 
field type that your web page lists as a supported type.

I need to have a running total of an integer field to appear in the list 
view of the database.

I have installed version 0.3.3.

Therefore, how do I sum field entries such as a total of "Hours" worked?

Sincerely, Mark Jefferis