pilot-db-list

[pilot-db-list] AW: AW: update crashes

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

Dear Scott,

I just tried creating a new database with the
*NEW* db-en-mobiledb.prc
I called the first field (float) fl1,
the second (float)fl2 and the third
(calculated) sum

I entered the foll. values

fl1 = 1.23456789
fl2 = 5.67890123

I tried to save the database and it crashed.

Thanks,

Hans


-----Ursprüngliche Nachricht-----
Von: Scott Wallace [mailto:swa...@my...]
Gesendet: Mittwoch, 31. Oktober 2001 21:52
An: Hans Ajiet Holtkamp
Betreff: Re: AW: update crashes



Ok,
	I didn't realize that you tried that latest version as well.. ;)
Marc made lots of changes between the two versions we're talking about,
so I'm not so sure he'll want to go back.  Anyway, I am thinking it might
be a good idea to use sourceforge for source control.  Have you guys tried
that before?  Emailing source around gets confusing  ;)

	-Scott


> Dear Scott,
>
> >the version you sent in your mail has now been integrated with marc's
most
> >recent changes.  Script support is continuing to improve.
>
> I think there is a misunderstanding here...
>
> I had *NO* problems with the version I mailed (i.e. the version you
> mailed to me).
>
> The versions I tried and which crashed WERE marc's
> most recent versions- the version he sent today -
>
> Or do you mean another not-yet-released version?
>
> Hans
>

--

[pilot-db-list] Float field alignment

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

Mike,
      this sounds like a good idea to me, I will take a look at what is
involved.  What do you think Marc?

	-Scott


Date: Wed, 31 Oct 2001 09:09:08 -0800 (PST)
From: Mike Ressler <mik...@al...>
To: Pilot db list <pil...@li...>
Subject: [pilot-db-list] Float field alignment

I am very pleased to see the new float field type. I had asked about it a
couple of years ago and offer three cheers to whoever implemented it. I do
have a small request though: I would find it much more useful to have the
numbers aligned on the decimal point, rather than left justified. I have a
large database of astronomical objects (which I hope to make public fairly
soon) and it is hard to get a quick sense of the numbers when the decimal
point wanders. Example:

	Now appears:			Would like:

	9.7				 9.7
	11.3				11.3
	12.4				12.4
	6.5				 6.5

Assuming the formating in my email survives, the right hand column is much
more legible, particularly for long lists with values typically between 7
and 12 (the curse of the magnitude system for measuring brightness in
astronomy). I suppose right justifying with a fixed number of decimal
places would be fine, though the recent discussion about printing
significant digits will require you to actually locate the decimal point
itself. Possible?

Mike



--

[pilot-db-list] Re: calculated field

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

I have just implemented this.  It is not quite circulating yet, but will
be very soon.  The function to access fields from other records is called
"fld" it takes 2 arguments both integers.  The first specifies an offset
from the current record ( so -1 is the record before it, and 1 is the
record after it).  the second argument is the field index, just as is used
with the '%<int>' notation.

	in essence the %<n>  is just a shorthand for (fld 0 <n>) in
the new version of db.

	There are still some things to be worked out (e.g. when to
recalculate these values) this is on the table, but not fully implemented.





Date: Wed, 31 Oct 2001 04:43:33 -0800 (PST)
From: Carson Wilcox <car...@fi...>
To: db list <pil...@li...>
Reply-To: car...@fi...
Subject: [pilot-db-list] calculated field

Can anyone explain how the calculated field works.
It was my hope that it would allow adding a field from the previous record with a field in the current record, but that doesn't seem to be the case.
Have I missed something?

Thanks,
Carson

[pilot-db-list] Re: update crashes

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

Perhaps these are fixed now.
the version you sent in your mail has now been integrated with marc's most
recent changes.  Script support is continuing to improve.

	-Scott

[pilot-db-list] update crashes

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

I used the db-en.prc and db-en-mobiledb prc.

The program crashed when I tried to open
a database that I created using Scotts
DB version (in which in the list view
displayed the no. of decimal places defined
in the global preferences and the edit view,
displayed all 8 decimal places -  a VERY GOOD
version!!!!!!!!!!!!!!!!!).

PLEASE base the future versions on his version
(attached)

Hans


-----Ursprüngliche Nachricht-----
Von: Chalain Marc [mailto:mar...@vo...]
Gesendet: Mittwoch, 31. Oktober 2001 18:06
An: Carson Wilcox; Holtkamp Hans; Larry W. Virden; Peter Kane; Philipp
Pott; Scott Wallace
Betreff: update the plugins


Can you try that?
Thanks a lot.
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] rescan probs

[chris a. <co...@au...>]

hi,

im using hotPaw to create a database.
if 've no error message at the creation

if i look in my databases list in DB, i can't see it !!
if i do a "rescan" it does'nt appear !!!

if i try to create a db with the same name DB says : "can't create : already
exists !!!"

can you help me ??

thx

Chris

[pilot-db-list] Float field alignment

[Mike R. <mik...@al...>]

I am very pleased to see the new float field type. I had asked about it a
couple of years ago and offer three cheers to whoever implemented it. I do
have a small request though: I would find it much more useful to have the
numbers aligned on the decimal point, rather than left justified. I have a
large database of astronomical objects (which I hope to make public fairly
soon) and it is hard to get a quick sense of the numbers when the decimal
point wanders. Example:

	Now appears:			Would like:

	9.7				 9.7
	11.3				11.3
	12.4				12.4
	6.5				 6.5

Assuming the formating in my email survives, the right hand column is much
more legible, particularly for long lists with values typically between 7
and 12 (the curse of the magnitude system for measuring brightness in
astronomy). I suppose right justifying with a fixed number of decimal
places would be fine, though the recent discussion about printing
significant digits will require you to actually locate the decimal point
itself. Possible?

Mike

-- 
Mike Ressler
mik...@al...
OK, I'm lame: I don't have my own website ...

[pilot-db-list] Re:Pilot-DB 0.3.3beta (28/10/2001): Filter

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

I think you use the text buttons version.
in the menu you can see the find command. When you search a string in the records now db display only the records which contain the string. This records are stored in one filter which you can select in the FindBox.
When you want see all records at the bottom select in the list "filter none". If you want see again the result of your search return in the list and select the good filter.

I hope that DB will have a documentation.
Salut,
Marc.

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

Re:[pilot-db-list] calculated field

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

Read the file README_SCRIPTS from Scott. you will find all informations. ar load the file help-en.prc to have some example inside pilot-DB.
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] calculated field

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

Can anyone explain how the calculated field works.
It was my hope that it would allow adding a field from the previous record with a field in the current record, but that doesn't seem to be the case. 
Have I missed something?

Thanks,
Carson


==
Carson R. Wilcox
Senior Systems Architect
DMR Consulting
Tampa, FL USA

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

Re: [pilot-db-list] Re: The New Version is *FANTASTIC*

[Mike R. <mik...@al...>]

On Tue, 30 Oct 2001, Scott Wallace wrote:
> I will write something about the floats/calculated fields.  What format do
> you want?  plain text?  Can I put markups in it? if so, should they be
> html to latex?
>
> > Will anyone be writing some documentation on this
> > version that I can put up on the WebSite?

Once I download and figure out how to use :-) the new beta, I'll try to
update the docs accordingly. Even though I've been pretty quiet (real
world intruding again), I've begun an tutorial section that I hope to
commit soon. It looks like I have more updating to do now!

Scott, if you would like to send me something LaTeX-ish, that would be
great. I'll incorporate it with the other stuff.

Mike

-- 
Mike Ressler
mik...@al...
OK, I'm lame: I don't have my own website ...

[pilot-db-list] New HTML Colour Code Database

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

Hi!

In case anyone is interested, I've just
created and added a new database:

HTML Colour Code:

A list of colours with popular German and English names
and the colour's HEX Code.

I do not guarantee that there are no mistakes, and
would be grateful if you could inform me if you
find any.

Thanks,

Hans

[pilot-db-list] Re: The New Version is *FANTASTIC*

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

I will write something about the floats/calculated fields.  What format do
you want?  plain text?  Can I put markups in it? if so, should they be
html to latex?

	-Scott

> Will anyone be writing some documentation on this
> version that I can put up on the WebSite?

[pilot-db-list] CSV Conversion Problem

[THIERRY D. <tde...@al...>]

I could not convert any csv file with csv2pdb tool, (I dowloaded it
yesterday)

Even simple files create with notepad like :
John, 40
Mark, 30

csv2pdb return "at least one list view must be specified"

Did I miss something ?
What is the right command, I tried all options ??

Thanx

[pilot-db-list] 0.3.3 beta 2

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

Sorry for the beta 1, but now we (the Pilot-DB team) give you the beta 2.
You can already download it on the website in the snapshot part.
I can tell this version is stable for the greatest part of the new features. You only should use the Calculated Field Type carefully, i hadn't merge the last update from Scott. Now we will add some internal mecanism, and some display.
We need your comments, bug reports (but not your requests for new features, for that you must use the website), not wait to write to us.

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] The New Version is *FANTASTIC*

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

Hi!,

Neat work!

Will anyone be writing some documentation on this
version that I can put up on the WebSite?

By the way, I just received an e-mail from the
Palm Development Program. They have a new
strategy which does not require sending the
agreement via post, which had kept me from doing
so. So I now have access to the official Palm
Rom Images.

Hans

Re:[pilot-db-list] French accents in DB...

[Miguel M. <mi...@yo...>]

Greetings...
On Mon, 29 Oct 2001 18:58:47 +0100, "Chalain Marc"<mar...@vo...>=
 wrote:
> this line in a csv file works fine, i haven't problem:
> "Anne","Rice","L'heure des sorci=E8res","Roman","Fantastique"
> Salut,
> Marc.
>=20
It does work actually even without using the escapes.
Thanks.  I thought it would be more complicated than that...

						Miguel

C. Miguel Marques, York University, Computing & Network Services
e-mail: mi...@yo..., voice: (416)736-2100x22684, fax: (416)736-5830
	=20

Re:[pilot-db-list] French accents in DB...

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

this line in a csv file works fine, i haven't problem:
"Anne","Rice","L'heure des sorci=E8res","Roman","Fantastique"
Salut,
Marc.

PS: i didn't try on my linux box sorry.
____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr 
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap. 

[pilot-db-list] (corrected) decimal places vs. significant places

[<hol...@di...>]

Dear Scott,

(Please answer to aji...@t-...)

You just convinced me that significant values shoud be used 
instead of decimal values in the case you mentioned:

> .00004, will just show up as zeros.  
> Maybe that's ok, I don't know.  

I don't think that is O.K.

Lets say you want to enter 0.0000012345

If you choose 2 significant values it should display
0.0000012

If you choose 2 decimal places it will display 
0.00 which, I do not believe is appropriate.

One could consider choosing the exponential display
if the no of digits requied to display a value would be
say 2 more than that of the decimal display.

take the above example again. 2 significant values are chosen
in the global settings:

the value entered is 0.0000012345

the values that could be displayed are 

0.0000012   which requires 9 digits to display
 or
1.2e-6     which requires 6 digits to display

Since the decimal diplay need >= 2 digits more than
that of the exponential display, we choose the
exponential display in this case.

This could be chosen as the standard rule, however one could
consider in addition to have a setting forcing either a 
decimal or exponential display.

These are just a few thougts...

Hans



To: swa...@my...
    pil...@li...


To: swa...@my...
    pil...@li...

[pilot-db-list] decimal places vs. significant places

[<hol...@di...>]

Dear Scott,

(Please answer to aji...@t-...)

You just convinced me that significant values shoud be used 
instead of decimal values in the case you mentioned:

> .00004, will just show up as zeros.  
> Maybe that's ok, I don't know.  

I don't think that is O.K.

Lets say you want to enter 0.0000012345

If you choose 2 significant values it should display
0.0000012

If you choose 2 decimal places it will display 
0.00 which, I do not believe is appropriate.

One could consider choosing the exponential display
if the no of digits requied to display a value would be
say 2 more than that of the decimal display.

take the above example again. 2 significant values are chosen
in the global settings:

the value entered is 0.0000012345

the values that could be displayed are 

0.0000012   which requires 9 digits to display
 or
1.21e-6     which requires 7 digits to display

Since the decimal diplay need >= 2 digits more than
that of the exponential display, we choose the
exponential display in this case.

This could be chosen as the standard rule, however one could
consider in addition to have a setting forcing either a 
decimal or exponential display.

These are just a few thougts...

Hans



To: swa...@my...
    pil...@li...

[pilot-db-list] French accents in DB...

[Miguel M. <mi...@yo...>]

Greetings...

I want to input a bunch of french book titles into a DB database using
pam-db-tools on a Unix box.
Can someone point me to some documentation or explain to me how I do
that without losing all the accents?  Do I just need to set the LANG
environment variable?
Thanks for any help...

							Miguel

C. Miguel Marques, York University, Computing & Network Services
e-mail: mi...@yo..., voice: (416)736-2100x22684, fax: (416)736-5830

[pilot-db-list] Re: Saving Float Values

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

The floating point stuff is almost ready for beta testing.
I did not have any time to work on it this weekend ;(
I need to merge Marc's changes into my code, before I distribute, and fix
a few glitches.


> Hi!
>
> I just wanted to know if you could tell me
> if you plan to be save a float-value with
> *ALL* the decimal points entered in the edit
> view (or better still as a double) ,
> regardless of the global setting
> which defines the no of decimal places to
> be *DISPLAYED*
>

The new float stuff saves everything in the float value as entered in the
edit form.

When in list view, it displays only the number of decimal points set using
the preferences, but when edit mode is re-entered, all digits are
displayed...

All the number format should be supported.

expect a version today or tomorrow.

-Scott

[pilot-db-list] Float (and everything else!) works

[<hol...@di...>]

Hi!

>When i change the number of digits from 1 to 2 the ListView and the 
>EditView display 4.57 without change in the record.

You are right. Sorry, my mistake
However I suggest that:

1) The EditView should always display all the decimal places, since
   you have 1 line for each value (also the calculated field)

2) The ListView should display the no. of decimal places defined in
   the global preferences.

>Have you save your PalmOS 3.3 ROM on your computer? if yes can you >send it to me, please?

I made a mistake and updated the OS to 3.52. I should have waited
till the Beta-Testing was over. My mistake again, sorry.

The ROM-transfers I did after adding the 2 MB Kit have always
resulted in the message "checksum is not correct" and in the
POSE crashing. However Scott has a 3.3 Version in which he had
the same problems with the older betas that I had.

Scott: Could you send me and marc the ROM?

Finally: Great work, I would suggest calling this version, after
         Beta testing 1.0.0!

To: swa...@my...
    mar...@vo...
    pil...@li...

[pilot-db-list] Saving Float Values

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

Hi!

I just wanted to know if you could tell me
if you plan to be save a float-value with
*ALL* the decimal points entered in the edit
view (or better still as a double) , 
regardless of the global setting
which defines the no of decimal places to
be *DISPLAYED*

Also I would appreciate it if someone
could explain the purpose of the
check boxes in the list and link views.

P.S. I have updated by OS to 3.52, which
I think was a mistake, since I cannot test
the 3.3 version, and I seem to be the only
person with this version: I should have waited
till the 1.0.0 version was released. Sorry!

Thanks,

Hans

Re: [pilot-db-list] The first 0.3.3 beta

[Anthony S. <asc...@ho...>]

The bug is still there where I open a database and nothing shows up. Filter 
shows "Filter None", but if I reselect it then everything shows up.  I tried 
to duplicate my database copying everything, but none of my data gets 
copied.  What can I do to fix this?


>From: "Chalain Marc"<mar...@vo...>
>To: "pilot-db list pilot-db" <Pil...@li...>
>Subject: [pilot-db-list] The first 0.3.3 beta
>Date: Sun, 28 Oct 2001 00:20:57 +0200
>
>i updated the snapshot with two files:
>  db-en.zip => 3 differents version of *.prc files (textbuttons+B&W, iconic 
>buttons + colors/grayscale, handera support) and the help-en.prc.
>  db-current.tar.gz => my last source codes
>
>New:
>  * List Field Type: you can build a list of items during the database 
>designing, and select one at the creation or the modification of a record.
>  * List Field Type: you can select a database and a field from this 
>database during the database designing and select a record from this linked 
>database at the creation or the modification of a record. When you tape on 
>the link field of a record you can jump to the linked database. This 
>feature is not very easy to use, you can lost the connection between the 
>databases.
>  * Float Field Type: Like Integer Type you can store a floating point 
>number (thank to Scott Wallace)
>  * Calculated Field Type: you can build a little script during the 
>database designing, and see the differents results in the records. This 
>feature should still be use carefully. (Great thank to Scott Wallace).
>  * Format Record Editing: you can select "use in EditView" during the View 
>editing, and only the view's fields are displaid in the EditView 
>(RecordView). You can display all fields when you tap the "All" buttons.
>  * Help strings file: The help strings are puted in a new file 
>"help-en.prc". If you need to read some help load this file. (the help 
>strings should be updated soon).
>  * Filters: When you search a string in the database you can choice the 
>filter where db will display the result. There is 4 filters.
>  * New Global Preferences: you can choice the font, the opening mode...
>  * Handera support: the slickScreen, the new fonts, the screen rotation 
>and the JogDial are supported.
>  * Sony support: the new font, and the JogDial are supported.
>
>Problems in this first beta:
>  * Sony support not complete.
>  * A record can be displaid only in one filter.
>  * Some bugs in the Calculated Type.
>  * the 0.3.2 plugins are not supported.
>
>Good download and send me your comments.
>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 mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp