pilot-db-list

[pilot-db-list] List field type

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

Not sure if I'm missing something, but I don't see a way to go back and add or delete items fro a list after it's created.
It would be usefull to have an edit list item automatically created in the list so the list could be changed on the fly. Is this a possibility?

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] proposals for better usage of DB

[hermann g. <hgr...@gm...>]

servus to all ;-)

some proposals:

1. when creating a new dataset in a database it would be fine to have 
the focus on the first entry, no need to tap the entry first, after 
editing the first entry it would be fine to have the possibility to 
scroll to the next entry with a graffiti action - similiar to editing 
an adress in the adressbook
2. it would be fine to have the possibility to search for a data 
entry, the date entry 13.11.01 can't be found by the tapping the 
search button
3. when searching was not successful the button for going back to the 
unfiltered view is present, here it would be more logical to have the 
search button again
4. possibly difficult to realize: the possibility to scroll to an 
entry by tapping the first letter is very useful (like in List) that 
would be a great feature for better usage ...
5. it would be nice to have the possibility to set up in the 
preferences whether a database is opened in read write mode or in 
read only mode

hope my proposals helps you to make a good program better ..

so long, ciao hermann

[pilot-db-list] 0.3.3 release

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

The new version looks good. I do have a couple of requests for the future.

1: A way to look at the current filter settings.
2: A way to return from a link back to the original db.

If there is already a way to do this and I missed it, I appologize, but could someone let me know how?

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] sony clie version problems

[Vasko M. <va...@di...>]

Hi,

I have some minor visual problems with Sony version of DB 0.3.3.

1. cursor is not visible, only when I click on record, before the record
pops up, cursor is visible for a moment (black on white-background
records
and almost-invisible bright white characters on grren-background
records)

2. text metrics are messed up. fields do not fit in view, database name
does not fit in title bar. field names in dialogs do not fit into form
fields, list-popups' (like field type, insert-when-list) arrows do not
match
their rows

3. jog-dial don't do page-up/page-down anymore. instead it scrolls "by
record".
but, because of cursor invisibility, it is useless

thanks for attention ;)
miro

[pilot-db-list] Re: the release???

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

Just one point:

Please right-allign the title of the float field
because the float field is also right-alligned.

I have not found any bugs.

Great!

Hans

-----Ursprüngliche Nachricht-----
Von: Chalain Marc [mailto:mar...@vo...]
Gesendet: Mittwoch, 14. November 2001 18:57
An: Schellenberg Anthony; Mike Ressler; Carson Wilcox; Holtkamp Hans;
Larry W. Virden; Peter Kane; Philipp Pott; Scott Wallace; Walter Koch
Betreff: the release???


I want your point of vue before to create the release with this version.
Salut,
Marc.
PS: there is a lot of internal modifications.
____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap.

Re: [pilot-db-list] db unstable

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

> At the current time, the find box have a trouble, but there is no bug at this point of the code source, then a real bug in another place rewrite the memory used at this point. I must find this error (and also the others).

	Speaking of the find function, I noticed that the find
doesn't work when the searched string is not in the few first
characters (haven't foundd how many, but I can try if you need)
of a string type field. 

	Fab.

Re:[pilot-db-list] Sample Application using pilot-db

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

ther is no simple application but you can find all source codes to store data in a db 0.3.x format in the db3.c file.
You can use too this file and the file datasource.h to not rewrite the driver. I think it's the best way.
Good luck
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] db unstable

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

DB grows and grows, now i found more and more trouble from the allocation memory. I must read again the code source and i find some memory allocations without desallocation. I must correct that.
At the current time, the find box have a trouble, but there is no bug at this point of the code source, then a real bug in another place rewrite the memory used at this point. I must find this error (and also the others).
Sorry i will be late for the new version.
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] =?big5?B?U2FtcGxlIEFwcGxpY2F0aW9uIHVzaW5nIHBpbG90LWRi?=

[<wo...@si...>]

Hi there,

Could someone please kindly send me any source code of sample Palm application which use pilot-db to store data (any beta version or very simple application are welcome) ??  So that I can learn how to store data to a pilot-db database format in the Palm application I'm developing.  
MILLION AND MILLION THANKS !!!

Martin
Wa
==================================================================
新浪免費電子信箱  http://sinamail.sina.com.hk

Re: [pilot-db-list] 0.3.3 release

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

My feelings are:

Whatever you release should be stable.  Many of the new features (Post 3.2)=
 are very nice and I'm sure many users could benefit from them.  However if=
 you need to trim some features back to get a stable release, this would be=
 acceptable.  Especially if you keep updating the Snapshot for the brave an=
d adventurous.

I have seen several things referring to snags in the calculated fields area=
.  If this need to be put aside for now, well those who want stability will=
 have to wait and those who want Calc Fields will have to be tolerant.

My 2c

LT

>>> Hans Ajiet Holtkamp <aji...@t-...> 11/09/01 02:51PM >>>
I am not sure if I have interpreted the answers
of Larry and James correctly:

Are you saying that we should or should not release
a version NOW

with=20
- Float, List and Link fields
- the JFile and Mobile-DB Plug-Ins

but without:=20

- VFS support and
- the calculated field?

As far as I can see the new float, list and link
fields ARE stable!.

Hans

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

[Fwd: Re: [pilot-db-list] 0.3.3 Release]

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

If they get upset, tell them you'll cut the cost of the application by half=
.   : )

LT

>>> Oliver Goetz <oli...@we...> 11/09/01 05:27PM >>>
Chalain Marc wrote:

<snip>

I don't think that anyone would be upset that a feature
that was announced for release 0.3.3 isn't implemented
yet.

Cheers,
	Oliver


--=20
Oliver Goetz, mailto:oli...@we...=20
     "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


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

[Fwd: Re: [pilot-db-list] Access Conduit]

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

This explanation of a conduit is exactly what I was asking about.  And I'm =
not suggesting that someone stop development on pilot-DB to work on this.  =
I was really just fishing for information as to weather anyone was working =
or thinking about working on this.

Currently I use Think-DB with DB-Sync, but I like some of the pilot-DB bett=
er than Think's

As to a CVS type conduit, I can get to this type of data almost as easily a=
s a standard Access DataBase.

Larry

>>> Oliver Goetz <oli...@we...> 11/09/01 05:27PM >>>
Hans Ajiet Holtkamp wrote:

 > I am not sure what a conduit is, but if
 > you are referring to an Access/Excel


As far as I understand it, a conduit is a piece of
software that manages the synchronization of data
when a Palm is synced with the desktop computer
(loke AvantGo Connect for example).

The Palm desktop software does this for the built-in
applications of the Palm (Calendar, Address Book, etc.),
but for proprietary software this synchronization
ability has to be provided as such a conduit.

Of course the DB databases are already synched to
the Backup directory on the PC if they have been
changed, but by default the syncing software can
only do that for a whole database because it has
no knowlegde about the data inside it.

The tricky part for such a conduit would be to
manage the synchronization on a per-record basis,
so that you can modify records on the Palm as
well as on the desktop database application.
The data of these two modified databases would
then have to be merged together to represent
the changes that were made on either side.

This could only be done if the conduit had a means
to decide which records have been changed on
Palm or on Desktop side, and in case the same
record has been changed on both sides, which is
the valid version (this can be very tricky, because
one can think of different scenarios where
different strategies could be applied).

Personally, I'd rather see something more generic
than an Access conduit, simply because I don't use
Access. But I'm not sure how such a solution could
look like. Maybe something that can use CSV-Files
on the PC side or a Java based conduit which would
allow to use JDBC to connect to any relational
database rather than a proprietory solution which
only works on one specific database system.
(Or maybe ODBC could be used for database access
on the desktop computer).


Cheers,
	Oliver

--=20
Oliver Goetz, mailto:oli...@we...=20
     "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


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

Re:[pilot-db-list] Bug reports: How?

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

For me it's the same:
 i read all mails of the mailing-list
 i read my mails
 and i receive a mail when a bug is updated in the trackers.
I think i prefer a mail in the mailing list, because i can correspond with the body who wrote it to have more informations. For a direct mail the problem comes from i think is better that every body know the trouble. I will use the tracker to keep a trace of bucks between two versions.

Salut,
Marc.


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

Re: [Fwd: Re: [pilot-db-list] 0.3.3 Release]

[Walter K. <ko...@u3...>]

Moin,

on Fri,  9 Nov 2001 23:54:16 +0100 Marc wrote:

>  i received some bugs reports.

Here is another one ...

(0.3.3beta 8.November 2001, Iconic with MobileDB, without plugins)

* After deleting a record, the list view scrolls to the very=20
  end of the view. It should IMHO show the next record of the=20
  deleted record=20

* Re-applying a filter to a changed database does not work:
  - Define a filter (e.g. "X" on filter 1; all fields).
  - edit a found record, so that no more "X" is contained
  - after returning to the list view, the just edited record is still
    visible (althoug it does not contain the filter expression=20
    any longer)
  - selecting the filter 1 does not help (the "X"-less record is=20
    still visible.
  - selecting "Filter none" (all Records are now visible) and=20
    reselecting "filter 1" still shows the "X"-less record.

* - Leave a database with a filter active
  - reenter the database. The list view still shows, that the filter is
    active; but the filter-drop-down-box shows "Filter none".

* sorting with find does not work always:
  - Databse with 2 Records; one string field; records "a" and "b".
  - Sort ascending, Filter None; List view shows:
       "a"
       "b"
  - Find string "b"; List view shows:
       "b"
  - "Sort descending" by tapping the colomn name. List view shows:
       "a"
    (and only the "a"-record)!
  - now selecting "Filter None" the List view shows:
       "a"
       "a"
    !

* After editing a record the list view shows always the first column,
  even if the list view showed the 20th column before starting editing
  the record.=20

* Linkfield:
  - create a Database with only one link field to a Stringfield=20
  - create a new record. Select a record in the linked database which
    contains a long text (say 220 characters).
  - save the record
  - edit this record and tap on the only field inside (the link-field=20
    to the long string)
  - Fatal exception

* A newly created List View is named "All Fields". This collides with=20
  the name of the automatic view "All Fields", which is present in every
  DB (BTW: a fine feature!). It is not an error, because it works, but
  the same names are disturbing.

* Plugin name "DB2" can be confused with name of IBM's Database "DB2".
  Maybe use "DB V.0.2" instead.

* Plugins (Mobile-DB, Jfile, DB2) didn't show in the list, while=20
  trying the DB-version without any plugins compiled in. I can not=20
  reproduce that every time.


Whishlist (in order of importance to me) (in the case somebody got to
much time :-)):

* Lookup function like in the adressbook for the last sorted coloumn

* Filter and sort setting stored together with the list views

* Seperate Filter name for the last used find ("Filter none"=20
  "last find" "Filter 1" "Filter 2" ...)

* Filter drop down list: append the corresponding findstring to=20
  each filter, so we can remember the function of the filter. Or
  allow a free name for the filter.=20

* Additional Find first / find next (like in the Mobile DB mode)

* New indiators for List view's horizontal scrolling for jumping=20
  fast to beginning (first column) and to the end (last column)=20
  of the view ( << and >>)

* Properties for every field:
    - Mandatory / optional=20
    - optional default value (e.g. "Now" for time; "Today" for Date)
    - optional max length for strings

* Listfields possible-value-list optional editable during record-edition

* Notefield contains a string field too. Wouldn't it be nice, if=20
  this string field isn't editable, but contains the first line=20
  of the content of the note? (That would break existing Databases=20
  with note fields)

* optional regexpression for filter

* Find dialog layout. Instead of=20
       V Filter1  [] Add the filter =20
  use better
       [] Add the filter  V Filter1=20
  this would be a little bit more logical (as least to me)


Thanks,
  Walter
--=20
  Hochdahl am Neandertal

Re: [pilot-db-list] record display/layout hints

[Walter K. <ko...@u3...>]

Moin,

Du schriebst am / on Mon, 5 Nov 2001 12:45:37 -0500 (EST) you wrote:

> You could select a field a do some clustering of the records based
> on the values in the field.=20

As in GROUP BY in SQL? Great Idea.

Gruss,
  Walter

--=20
  Hochdahl am Neandertal

[pilot-db-list] Bug reports: How?

[Walter K. <ko...@u3...>]

Moin,

on Fri, 9 Nov 2001 23:54:16 +0100 Marc wrote:

>  i received some bugs reports.

How should bugs report be transmitted?

 [ ] To this list
 [ ] To Marc
 [ ] To sourceforge's bug tracker

or all above?


Gruss,
  Walter


--=20
  Hochdahl am Neandertal

[pilot-db-list] Field/Title allignment, esp. Float

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

I had written:
>The only problem I have found as yet (0.3.3) is that the 
>width of the float field does not seem to be influenced by 
>the values entered in the 'Edit List Views' dialog.

This is not quite correct:

If a field is the only or the last of the displayed fields,
then the width of the field is not influeced by the value
definded in the 'edit list views' dialog.

This is OK if the title and content of the fields are 
left-alligned.

If, however, as is the case of float, the content is
right allined and the tilte is left alligned, the 
values entered are not displayed under the tilte,
which is a bit confusing (still does not classify a 
bug, I admit).

My suggestion is to allign the tilte and the contents
of the fields in the same fashion.

In case of float, there are two allignments:
one is that the decimal points are alligned
under each other, which is GREAT and is a must, I think.
However, in addition the field seems to be right-alligned 
which I do not think is necessary if the decimal points
are alligned under each other.

So if it is possible to keep the decimal point allignment
and in addition a left-allignment, I would prefer that.

Hans

Re: [pilot-db-list] Script Support

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

> do something better here in the future.  Someone also suggested not
> storing the values at all.  I think this may be a reasonable future
> option.

	I did suggest that, so I must agree :-)


> > 	Couldn't we imagine a simple awk program to convert databases
> > provided that the db-tools are able to translate the new types in a csv file ?
> Covert databases into what?  Do you mean from the old script format to the
> new one?  It could definately be done.  Its just whether or not the time
> is better spent somewhere else.

	It was just a thought, but if you're near the end of the new dev
keep it as just a thought :-)


	Fab.

[pilot-db-list] Release 0.3.3!

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

The only problem I have found as yet is that the width of
the float field does not seem to be influenced by the
values entered in the 'Edit List Views' dialog.

However I do not think this qualifies as a 'bug'.

I am really impressed by the fact that all float values are
alligned with the decimal point. GREAT

I am also impressed by the fact that in the list field dialog,
if the number of items entered exceeds the no of items displayed,
the list is automatically scrolled down to the latest entered value.

Re. the localised float display:

If I enter a value and by mistake have used the wrong decimal 
point representation, the value I have (wrongly) entered
is overwritten by [nan] (not a number) in the list view, 
and I have to re enter the value again, which, in some cases 
could be tedious, e.g if I have to look it up again in some
table, especially if I have entered many wrong values in many
float fields.

Scott had said that he wanted to implement it in such a way that 
you cannot leave the edit view if a non-recognised decimal or
character is entered.

This makes sense. Let us say the format used is the english format
1,000.00 and one enteres say 123,456 instead of 123.456.

If you TRY to leave the edit view, it would be nice if the following
pop-up window would appear:
'the syntax in 123,456 is wrong'.

Even better would be the recogintion of the wrong decimal representation
with a window saying

'wrong decimal syntax' and 
'the syntax in 12.a456 is wrong' if 12.a456 is the value entered, 
i.e. if  a character is entered by mistake.

This would still give you the chance of going back and just changing
the wrong decimal or digit instead of having to enter everything again.

However, this is also not a bug by any definition, so in my
opinion, this version can be released

Once again, what an outstanding piece of software!

Hans

[pilot-db-list] Re: 0.3.3 Release

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

I think that this is a good idea as well, we will save the Calculated
field until the next release.  That way I can iron out a few remaining
decisions and make sure that it will remain compatible for potential
future uses.

	-Scott

Re: [pilot-db-list] Pilot-DB 0.3.3 release

[Tom D. <td...@us...>]

On Friday 09 November 2001 08:10 pm, mr...@cr... wrote:

> By the way, can someone explain what "snapshot" updates are?

A "snapshot update" is a "snapshot" of the code at a certain point in time. 
It is just a different name for what I called "test release" when I did 
releases. Actually, most open source projects use "snapshot" as the word to 
describe releases between official versioned releases.

Re: [pilot-db-list] Conduit!

[Tom D. <td...@us...>]

On Friday 09 November 2001 07:32 pm, Philipp Pott wrote:

> that's why I wanted to first focus on writing a:
>
> - connection between palm-db-tools/Excel or Access
> - import/export-tool which support all the fields of PalmDB
> - front-end for editing PalmDB-pdb's directly
>
> I think after that we can focus on a conduit and ODBC-connections. If
> someone can't wait for conduit and ODBC AND want's to contribute to this,
> he could contact me and Marc Chalain - we should then synergize.

If you would like to help out with palm-db-tools, let me know and I will let 
you commit directly to its repository. Code for the float field type has been 
added but I still need to add the other new field types. The code is all 
standard C++ that compiles with Visual C++ 6.x on Windows and gcc on Linux 
and other UNIX platforms.

And if you want a DLL of the palm-db-tools, you can make DLL's out of the 
support library by just changing the build type is the Visual C++ project 
files. :)

[pilot-db-list] Pilot-DB 0.3.3 release

[<mr...@cr...>]

Hans, I believe you should release now with float, list, and link, but without VFS 
(whatever that is) and the calculated field.  I am eagerly awaiting the calculated field 
feature, but I can wait.  I'd much rather see continued stable releases and 
accompanying toolkits rather than rushing anything.  Whatever field types I have, I 
want the toolkit updated along with the software update.

By the way, can someone explain what "snapshot" updates are?

On 9 Nov 2001 at 12:10, pil...@li...urceforge.n wrote:

> Message: 11
> Reply-To: <aji...@t-...>
> From: aji...@t-... (Hans Ajiet Holtkamp)
> To: <pil...@li...>
> Date: Fri, 9 Nov 2001 20:51:22 +0100
> Subject: [pilot-db-list] 0.3.3 release
> 
> I am not sure if I have interpreted the answers
> of Larry and James correctly:
> 
> Are you saying that we should or should not release
> a version NOW
> 
> with 
> - Float, List and Link fields
> - the JFile and Mobile-DB Plug-Ins
> 
> but without: 
> 
> - VFS support and
> - the calculated field?
> 
> As far as I can see the new float, list and link
> fields ARE stable!.
> 
> Hans

======================
Michael Reich
mr...@cr...
======================

[pilot-db-list] Conduit!

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

Hi there,

since in my first euphorism about PalmDB I proposed to write a conduit, =
I had some thoughts about implementing a conduit into PalmDB. Let  me =
summarize:

- a conduit is a 'dll' (on the Windows side, I didn't look at Linux yet) =
which awakes as soon as you press the sync button AND if db offers a =
PalmDB database *.pdb
- the action then to be taken is to sync with a) some file on the =
desktop b) a ODBC-source on the desktop c) directly with a database over =
TCP/IP
- on the other hand a sync of PalmDB with a desktop or server database =
could also be done over NET-commands directly online
- anyway you have to keep track of the changes in both the database on =
the Palm and the desktop/server-app
- this requires a sync-field in PalmDB - either the built-in =
sync-mechanism of PalmOS or if required some additional for PalmDB
- but at least in the desktop/server-App (this is the way MobileDB does =
it) - a field to field comparison would take too long!

that's why I wanted to first focus on writing a:

- connection between palm-db-tools/Excel or Access
- import/export-tool which support all the fields of PalmDB
- front-end for editing PalmDB-pdb's directly

I think after that we can focus on a conduit and ODBC-connections. If =
someone can't wait for conduit and ODBC AND want's to contribute to =
this, he could contact me and Marc Chalain - we should then synergize.

Hans, it's great how you motivate us all for this great program and =
project! I thank you and will take your comments as a motivation for my =
work!

Bye

Philipp Pott

Re:[Fwd: Re: [pilot-db-list] 0.3.3 Release]

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

Sorry, i thought to release the 0.3.3 version this night, but i received some bugs reports. Then i will only upload the snapshot. If you find more bugs please send a report as quickest as possible. We need you.

To know the bugs are:
 * when you create a link and don't select a datase and a field.
 * in the display of some box with the HANDERA version.

The last corrections:
 * When you hit the scroll down key in a new records it doesn't do anything.
 * the SONY display works bette on Emulator, i haven't report from a device.
 * the scrolling in the List Field creation.
 * new icons (color and small) not a lot of modification.

But i can't to promise to you that Pilot-DB will be free of bugs, we will try to correct the maximum.

Salut,
Marc.


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