pilot-db-list

[pilot-db-list] Pilot-DB

[Richard S. <sch...@us...>]

Great program at an even better price!!!

When ya'all get some spare time, I have a couple of feature requests.  1)
Store a default multi-column sort order with Listview settings.  2)  Allow
null dates.

=/\=  Rich
sch...@us...

[pilot-db-list] adding field links

[Lawrence S. <spr...@ya...>]

I need the ability to link fields between tables. I
have an idea on how to do that, but need to know a
little bit about tha basic structure of DB and where
in the code I need to modify in order to get the
links.
Basically, I would like to add a field type 'link'
that would refer to a field in another table. where in
the source do I find the code for field type
definitions etc.

Or, can anyone do this?

=====
Check out my WebsiteTry  PayPal for making and reciving payments online from your bank account or credit card.

__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com

[pilot-db-list] Added 'Links' Menu Item to the Pilot-DB WebSite

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

This is just to inform everyone that a Menu-Item
'Links' has been added to the Pilot-DB Web-Site.

Hans

Re: RE: [pilot-db-list] leading 0

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

Greetings...
On Wed, 26 Sep 2001 08:21:50 +1000, "KANE Peter (CA)" <Pet...@er...> wrote:
> To me this is a very strange thread indeed.
> 
> An integer is an integer. no matter how many leading zeros it is entered
> with, it should be stored as an integer, and formatted and displayed in a
> consistent format for integers.
> 
> A more useful discussion would be about whether db should have user-defined
> formatting of integers, or other number types in the future (or strings for
> that matter).
> 

I couldn't agree more...

						Miguel

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

RE: [pilot-db-list] leading 0

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

Marc is correct in his feeling on this. 
For example open any spreadsheet and enter an integer with a leading 0 and see what happens to the 0.

Carson

--- "KANE Peter (CA)" <Pet...@er...>
> wrote:
>To me this is a very strange thread indeed.
>
>An integer is an integer. no matter how many leading zeros it is entered
>with, it should be stored as an integer, and formatted and displayed in a
>consistent format for integers.
>
>A more useful discussion would be about whether db should have user-defined
>formatting of integers, or other number types in the future (or strings for
>that matter).
>
>
>-----Original Message-----
>From: Chalain Marc [mailto:mar...@vo...]
>Sent: Wednesday, 26 September 2001 2:23
>To: pilot-db list pilot-db
>Subject: [pilot-db-list] leading 0
>
>
>I will never keep the leading 0. An integer is a value not a phone number or
>other thing like that. How do you want to do an operation with two phone
>numbers???????
>Ok, for an explanation about the meaning of String Type in the
>documentation, it's necessary. (Mike can you just add that in your first
>documentation, please?)
>For the type of the entry (decimal, hexadecimal, octal) i think it's better
>to keep it, perhaps i can change the mode to understand the type. And i
>don't see a problem to use it. For the number display is another deal, i
>don't want to add a lot of informations in the database, if you have an
>idea, i listen you.
>Salut,
>Marc.
>__________________________________________________
>Voila vous propose une boite aux lettres gratuite sur Voila Mail:
>http://mail.voila.fr
>
>
>
>
>
>
>
>This e-mail (including any attachments) may contain confidential or
>privileged information and is intended for the sole use of the person(s) to
>whom it is addressed. If you are not the intended recipient, or the person
>responsible for delivering this message to the intended recipient, please
>notify the sender of the message or send an e-mail to
>mailto:hel...@er... immediately, and delete all copies. Any
>unauthorised review, use, alteration, disclosure or distribution of this
>e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
>responsibility for the content of any e-mail sent by an employee which is of
>a personal nature.
>
>Ergon Energy Corporation Limited      ABN 50 087 646 062 
>Ergon Energy Pty Ltd      ABN 66 078 875 902
>
>
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list

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

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

[pilot-db-list] DB on the net:)

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

What do you think about a Link page in your website?
You can list all websites where we can find DB.
I begin:
PalmGear:
http://www.palmgear.com/software/showsoftware.cfm?sid=3D39136820010619023750&prodID=3D2175
Handango:
http://www.handango.com/PlatformProductDetail.jsp?siteId=3D1&platformId=3D1&productType=3D2&productId=3D19660&sectionId=3D0&catalog=3D1
Tucows:
http://proxad.pda.tucows.com/palm/preview/34767.html
Palm Boulevard:
http://www.palmblvd.com/software/pc/DB-Pilot-DB-2001-8-31-palm-pc.html
FreewarePalm:
http://www.freewarepalm.com/database/db(pilot-db).shtml

in French:
PalmGaulois:
http://www.palmpilot-gaulois.younix.com/sgbd1.html
IziPalm:
http://www.izipalm.com/bd.htm

Salut,
Marc.

__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re:[pilot-db-list] PDA Forums.com

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

Thanks but Where????
Salut,
Marc.


__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re: [pilot-db-list] Re: 0.3.3 again

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

I admit I'm not crazy about the grayscale, but I didn't notice any slowness in the scrolling.

Carson

--- Fab <kr...@bi...>
> wrote:
>> > Can you tell me your point of view about the speed of this version?
>> 	It seems correct, perhaps a little slower, but I compare with
>> the version where we don't have grey scales.
>> 	BTW, the label bar of the display is too dark and I cannot read
>> the black labels in it. Don't like the light-grey lines in the list display,
>> too.
>
>	In fact the scrolling is veeeeery slow with the grayscale version.
>Too slow specially compared to the raw version with text labels.
>	Fab.
>
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list

==
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] leading 0

[KANE P. (CA) <Pet...@er...>]

To me this is a very strange thread indeed.

An integer is an integer. no matter how many leading zeros it is entered
with, it should be stored as an integer, and formatted and displayed in a
consistent format for integers.

A more useful discussion would be about whether db should have user-defined
formatting of integers, or other number types in the future (or strings for
that matter).


-----Original Message-----
From: Chalain Marc [mailto:mar...@vo...]
Sent: Wednesday, 26 September 2001 2:23
To: pilot-db list pilot-db
Subject: [pilot-db-list] leading 0


I will never keep the leading 0. An integer is a value not a phone number or
other thing like that. How do you want to do an operation with two phone
numbers???????
Ok, for an explanation about the meaning of String Type in the
documentation, it's necessary. (Mike can you just add that in your first
documentation, please?)
For the type of the entry (decimal, hexadecimal, octal) i think it's better
to keep it, perhaps i can change the mode to understand the type. And i
don't see a problem to use it. For the number display is another deal, i
don't want to add a lot of informations in the database, if you have an
idea, i listen you.
Salut,
Marc.
__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr







This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062 
Ergon Energy Pty Ltd      ABN 66 078 875 902

[pilot-db-list] PDA Forums.com

[admin <ad...@pd...>]

We are going to add your link to our site at PDAForums.com.
If you would please be so kind as to add a link to us at www.pdaforums.com as well, it would be appreciated!

PDA Forums.com is the new online forum community for peer-to-peer sharing of experiences, tips, tricks, and general know-how for 99.9% of the handheld devices available worldwide.
If we don't have a forum for the device you need, e-mail us, and we'll add one!

Best regards

Frank Osborne
Editor in Chief
www.pdaforums.com 




________________________________________________________________
Sent via the WebMail system at pdaforums.com


 
                   

Re: [pilot-db-list] Re: 0.3.3 again

[Fab <kr...@bi...>]

> > Can you tell me your point of view about the speed of this version?
> 	It seems correct, perhaps a little slower, but I compare with
> the version where we don't have grey scales.
> 	BTW, the label bar of the display is too dark and I cannot read
> the black labels in it. Don't like the light-grey lines in the list display,
> too.

	In fact the scrolling is veeeeery slow with the grayscale version.
Too slow specially compared to the raw version with text labels.
	Fab.

Re: [pilot-db-list] leading zero's

[Fab <kr...@bi...>]

> It doesn't seem obvious to me that non-technical users will make
> the assumption that phone numbers, social security numbers, passwords,
> etc. that are numeric should be stored in something called 'string'
> if they are going to need to keep leading zeros.

	It doesn't need to be that obvious to be usable :-)))
	If users can't imagine or deduct it from a simple try, they
probably won't do anything usefull with a database program :-)))))

> Seems to me to be much more PalmOS friendly to keep whatever the
> user types just the way they type it.
	Not a the point to transform the way an integer is stored.
Say the leading "0" is kept, you have to internally store the
number in a string, for the integer type in whatever language you
choose discard all leading zeros. Then you get some problems : each
time you want to compute with the number you have to convert it,
with performances consequences (great), you get size problems (same
than dimensionning a string field), etc... You could say, well, store
it as both the integer, and the way it has been entered, but that
leaves the sizing problem, at the cost of a bigger database.

	Fab.

[pilot-db-list] Re: 0.3.3 again

[Fab <kr...@bi...>]

> Can you tell me your point of view about the speed of this version?

	It seems correct, perhaps a little slower, but I compare with
the version where we don't have grey scales.
	BTW, the label bar of the display is too dark and I cannot read
the black labels in it. Don't like the light-grey lines in the list display,
too.

	And I definitly prefer the version without icons :-)

	Fab.

[pilot-db-list] leading 0

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

I will never keep the leading 0. An integer is a value not a phone number or other thing like that. How do you want to do an operation with two phone numbers???????
Ok, for an explanation about the meaning of String Type in the documentation, it's necessary. (Mike can you just add that in your first documentation, please?)
For the type of the entry (decimal, hexadecimal, octal) i think it's better to keep it, perhaps i can change the mode to understand the type. And i don't see a problem to use it. For the number display is another deal, i don't want to add a lot of informations in the database, if you have an idea, i listen you.
Salut,
Marc.
__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re: [pilot-db-list] leading zero's

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

From: Oliver Goetz <oli...@we...>

> I have to disagree! 

Certainly your privledge.

> If you want to store a sequence of numbers or characters exactly
> as you enter it, then use a string.

It doesn't seem obvious to me that non-technical users will make
the assumption that phone numbers, social security numbers, passwords,
etc. that are numeric should be stored in something called 'string'
if they are going to need to keep leading zeros.

Seems to me to be much more PalmOS friendly to keep whatever the
user types just the way they type it.
-- 
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.
-><-

Re: [pilot-db-list] leading zero's

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

Larry W. Virden wrote:

>>A leading zero serves no purpose, it doesn't change
>>the value of the number.
>>
> 
> A leading zero does serve a purpose actually - if one is keying in a
> password that includes a leading zero, then dropping it leaves one
> without the knowledge of whether it is needed or not.
> 

I have to disagree! If you want to use a number field, then the
numbers should be handled and stored mathematically correct.
As a number, 1234 is the same as 01234. If you display it with
leading zeros, then it's just that: a formatting convention
for display purposes.

If you want to store a sequence of numbers or characters exactly
as you enter it, then use a string.


> Rather than trying to make assumptions of what the user of a package
> needs, I recommend leaving what someone types into a field EXACTLY as
> they type it.  If a field has entry contraints, just don't let the
> wrong kind of data be entered into the field in the first place.
> 
The creator of the database has to determine what he or she

wants to store and chose the field types accordingly. Storing
a number in such a way that leading zeros are stored with it
makes no sense to me.

BTW, storing the number as a string EXACTLY as it was entered
by the user would be making an assumption about what the user
wants to do with it later as well.

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] Modifications to DB

[Fab <kr...@bi...>]

> 	-is this a feature that anyone else is particularly interested in?

	Yes! I am! :-)
	Fab.

[pilot-db-list] Modifications to DB

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

Hi,

	I've been playing around with the DB source, and am thinking about
making some modifications.  In particular, I'm very interested in adding
calculated fields.  I'm hoping I can get a number of different features
from them:

	1.  calculate intra-record values (all data from a single record)
	2.  calculate inter-record values (data from 2 or more records)
	3.  calculate global values (e.g. summary information)

	I have made some progress on an old version of db, but before
I sync up with the new version, I was hoping to get some feedback.

	-is this a feature that anyone else is particularly interested in?
	-is this a reasonable time in db's life to begin this addition?
	-assuming the 2 above are true, what steps are necessary to
		help ensure that my code will be 'easy' to integrate
		with db in the future?


	in addition there obviously a number of important design decisions
that will need to be made. If there is relative support for this type of
modification I would input before I get too far into it.

	thanks,

	-Scott

Re:[pilot-db-list] Is this a Bug in DB (Pilot-DB) 0.3.2?

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

I agree that this is correct , IMHO

Carson
--- Chalain Marc <mar...@vo...> wrote:
> Are you sur that is not 83:)
> In fact 0123 is the octal value of 83d.
> Integer Type Field accept decimal, hexdecimal and
> octal:
>   123   -> 123d
>   0123  -> 83d
>   0x123 -> 291d
> It's not a bug, it's a Tom's feature, and i like it.
> Salut,
> Marc.
> 
> 
> __________________________________________________
> Voila vous propose une boite aux lettres gratuite
> sur Voila Mail:
> http://mail.voila.fr
> 
> 
> 
> 
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
>
https://lists.sourceforge.net/lists/listinfo/pilot-db-list


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com

[pilot-db-list] int field, etc.

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

At Mon, 24 Sep 2001 15:07:18 +0200 , "Chalain Marc"
<mar...@vo...> wrote:

>Sorry, but an octal integer is an integer as a
decimal integer.
That's fine Marc, I believe that's how it should be.

>My problem is if a transform Integer Type Field in
Decimal Type Field after some body will want to have
the Hexadecimal Type Field and the Octal Type Field,
and after a new field to convert one in another type.
>But in every case the first 0 will never be keeped,
and integer is a value not a string, if you want to
keep 0123 you must select a String Type Field!!!
That's what I meant to say, sorry if I missed.

>For the Calculated Type Field, it's another problem.
It's a very hard feature. I don't know if i will able
to implement it in the next version. But i keep the
idea to add it.
That's fine, when ever you can.

Thanks,
Carson

>Salut,
>Marc.


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com

Re:[pilot-db-list] leading zero

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

Sorry, but an octal integer is an integer as a decimal integer.
My problem is if a transform Integer Type Field in Decimal Type Field after some body will want to have the Hexadecimal Type Field and the Octal Type Field, and after a new field to convert one in another type.
But in every case the first 0 will never be keeped, and integer is a value not a string, if you want to keep 0123 you must select a String Type Field!!!
For the Calculated Type Field, it's another problem. It's a very hard feature. I don't know if i will able to implement it in the next version. But i keep the idea to add it.
Salut,
Marc.
__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

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

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

Baruch Even wrote:



> Add a field type called 'name' or 'person', such a field should be
> lookup-able from the address book, specific scenario for this is a
> "loaned stuff" database, I want to place peoples in there and to be able
> to just look them up from the address book. It would be great if I could
> also goto their address book record when viewing the database.

I try to add a Link Type Field, and it's hard.

> One function sorely missing is move-up/down in fields, this is a
> graffiti keystroke that works in most applications to travel between
> fields.

Like the previous mail about keyboard, i add that in the next version.

> A matter of taste, but I'd like to have the field names automatically
> starting with a capital letter, without me needing to do an extra
> keystroke (yes, I'm lazy, that's why I got the PalmPilot :-)

If other people want.

> Continuing the former idea, I'd love the ability to signify that a field
> in the database should start with a capital letter.

No, too hard, too much datas in the database.

Salut,
Marc.
__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re:[pilot-db-list] Db-Source code

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

Yes, i build DB under Linux Box and "Fenetres" Box.
Under Windows you should install the Cygwin environnement and the prc-tool utilities at: prc-tool.sourceforge.net
The source code of DB are: first on the CVS tree, second on the download page (db-0_3_2.tar.gz). For the alpha version i can to send it, i didn't update the CVS tree because i have a lot of trouble on my Linux Box and can often use it because my son sleeps in the computer room. At work have only http access.
Salut,
Marc.
PS: if you want the last update send me a email!

__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re:[pilot-db-list] one more feature request

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

> When leaving an edited but unsaved record, the program should ask if I
> want to save, discard or cancel. I've lost some written records because
> I pressed the wrong button.
It's already implemented in the 0.3.3
Salut,
Marc


__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re:[pilot-db-list] Is this a Bug in DB (Pilot-DB) 0.3.2?

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

Are you sur that is not 83:)
In fact 0123 is the octal value of 83d. 
Integer Type Field accept decimal, hexdecimal and octal:
  123   -> 123d
  0123  -> 83d
  0x123 -> 291d
It's not a bug, it's a Tom's feature, and i like it.
Salut,
Marc.


__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr