pilot-db-list

Re: [pilot-db-list] Re: Horizontal scroll restriction

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

To eleminate this: add a checkbox to the database called 'End' and use it as the last displayed item on your troubled views. 
 
Larry 
 
 
Tom Dyas <td...@va...> wrote on 10/31/00 11:29 pm: 
 
On Mon, 30 Oct 2000, Ian Jackson wrote: 
 
> I have a database with a view which prevents me from scrolling as far 
> to the right as I'd like.  Here is the `info' file: 
>  
>  title "Books" 
>  field "Author" string 
>  field "Title" string 
>  field "!mine" boolean 
>  field "Genre" string 
>  field "Vol" string 
>  field "Notes" string 
>  view "All Fields"  "Author" 80 "Title" 80 "!mine" 80 "Genre" 80 "Notes" 80 
>  view "Standard"  "Author" 57 "Title" 74 "!mine" 12 "Genre" 16 "Vol" 32 "Notes" 80 
>  option backup false 
>  extended on 
>  
> To reproduce: use pdb2csv to turn this (plus an empty .csv) into a pdb 
> and install it.  Select the `Standard' display.  Now you will find 
> that you can't see the whole width of the `Notes' field. 
 
DB allocates space on the list view by starting with the leftmost column 
and giving each column either its width or the amount of space remaining. 
If you add up every column but the Notes column, you get 31 pixels 
remaining. Then it sets the scroll arrows to allow scrolling only if there 
are fields on the other side of the last column. Thus, the last column 
will get truncated with the current algorithm. 
 
 
_______________________________________________ 
Pilot-db-list mailing list 
Pil...@li... 
http://lists.sourceforge.net/mailman/listinfo/pilot-db-list 
 
 
The Following file(s) are attached to the GroupWise message: 
Heade

[pilot-db-list] Re: Horizontal scroll restriction

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

On Mon, 30 Oct 2000, Ian Jackson wrote:

> I have a database with a view which prevents me from scrolling as far
> to the right as I'd like.  Here is the `info' file:
> 
>  title "Books"
>  field "Author" string
>  field "Title" string
>  field "!mine" boolean
>  field "Genre" string
>  field "Vol" string
>  field "Notes" string
>  view "All Fields"  "Author" 80 "Title" 80 "!mine" 80 "Genre" 80 "Notes" 80
>  view "Standard"  "Author" 57 "Title" 74 "!mine" 12 "Genre" 16 "Vol" 32 "Notes" 80
>  option backup false
>  extended on
> 
> To reproduce: use pdb2csv to turn this (plus an empty .csv) into a pdb
> and install it.  Select the `Standard' display.  Now you will find
> that you can't see the whole width of the `Notes' field.

DB allocates space on the list view by starting with the leftmost column
and giving each column either its width or the amount of space remaining.
If you add up every column but the Notes column, you get 31 pixels
remaining. Then it sets the scroll arrows to allow scrolling only if there
are fields on the other side of the last column. Thus, the last column
will get truncated with the current algorithm.

Re: [pilot-db-list] Desktop Interface for DB?

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

On Tue, 31 Oct 2000, Larry W. Virden wrote:

> I'm not familar with what mobileDB has - I don't use a PC and so many of
> those software packages remain unknown to me.

MobileDB is a PalmOS application similar in function to DB. Other similar
programs would be JFile, List, ThinkDB, HandDBase, etc.
 
> What kinds of features does this desktop app have that would be useful?

The motivation for adding MobileDB support was that there is a lot of
content in this format and letting DB be able to read that content
directly would be good.

Re: [pilot-db-list] Desktop Interface for DB?

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

I'm not familar with what mobileDB has - I don't use a PC and so many of
those software packages remain unknown to me.

What kinds of features does this desktop app have that would be useful?
-- 
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.
-><-

[pilot-db-list] Desktop Interface for DB?

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

Has anyone created a desktop interface for DB, similar to the mobileDB-PC
program?
_______________
Peter Kane
Ergon Energy Capricornia
PO Box 308 (185 Richardson Rd) Rockhampton Q 4700
Phone: (07) 4931-2658; Fax:  (07) 4931-2238
mailto:pet...@er...
http://www.ergon.com.au



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.

[pilot-db-list] test release

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

ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-en.prc - English
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.tar.gz - Source Code

Changes:

* Sorting support in the MobileDB driver. So all 3 drivers can sort
  properly.

* Fixed bug in MobileDB driver which caused it to improperly unpack
  records which omitted empty fields.

* Fixed the duplication feature so it can handle duplicating to drivers
  which don't support all the field types of the source driver.

[pilot-db-list] \xNN in extended CSV format

[Ian J. <ija...@ch...>]

Tom Dyas writes ("[pilot-db-list] sorting UI changed"):
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-en.prc - English
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-de.prc - German
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-pt.prc - Portuguese
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.tar.gz - Source Code

The extended CSV format understood by pdb2csv and csv2pdb is
unfortunately rather hard to un-parse for arbitrary data.  There is an
escape code \ddd for arbitrary character values, but it keeps eating
digits potentially forever, making it cumbersome to represent strings
with escaped bytes followed by digits.

Here is a patch, which I've tested and I hope is correct, to have it
accept two-digit \xXX hex escapes as well.  I'm afraid it's not a very
C++-like patch, but it is quite short.

While testing this patch (and doing some database massaging) I found
that pdb2csv can produce garbled output for me !  I'm pretty sure it's
not the attached patch, because the garbled output from pdb2csv
contains things that don't appear to be in the .pdb file if I look at
it in Emacs - and the .pdb file works fine in my Palm.

To help you reproduce this I'll send you a copy of the input to
pdb2csv and the corresponding .pdb file that it generates under
separate cover.  (Both to spare the list my database, and to avoid
publishing it.)  I'm afraid I haven't really investigated the bug.

Ian.

--- strop.cpp~	Sun Oct 15 06:07:57 2000
+++ strop.cpp	Mon Oct 30 00:11:21 2000
@@ -205,6 +205,17 @@
 	    case '"':
 		elem += '"';
 		break;
+	    case 'x':
+		{
+		    if (p+1 == str.end() || p+2 == str.end())
+			throw StrOps::csv_parse_error("truncated hex");
+		    char buf[3];
+		    buf[0]= *++p;
+		    buf[1]= *++p;
+		    buf[2]= 0;
+		    elem += static_cast<char> (strtoul(buf,0,16) & 0xFFul);
+		    break;
+		}
 	    case '0': case '1': case '2': case '3': case '4':
 	    case '5': case '6': case '7': case '8': case '9':
 		{

[pilot-db-list] Horizontal scroll restriction

[Ian J. <ija...@ch...>]

Tom Dyas writes ("[pilot-db-list] sorting UI changed"):
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-en.prc - English
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-de.prc - German
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-pt.prc - Portuguese
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.tar.gz - Source Code

I have a database with a view which prevents me from scrolling as far
to the right as I'd like.  Here is the `info' file:

 title "Books"
 field "Author" string
 field "Title" string
 field "!mine" boolean
 field "Genre" string
 field "Vol" string
 field "Notes" string
 view "All Fields"  "Author" 80 "Title" 80 "!mine" 80 "Genre" 80 "Notes" 80
 view "Standard"  "Author" 57 "Title" 74 "!mine" 12 "Genre" 16 "Vol" 32 "Notes" 80
 option backup false
 extended on

To reproduce: use pdb2csv to turn this (plus an empty .csv) into a pdb
and install it.  Select the `Standard' display.  Now you will find
that you can't see the whole width of the `Notes' field.

Ian.

Re: [pilot-db-list] sorting UI changed

[Ian J. <ija...@ch...>]

Tom Dyas writes ("[pilot-db-list] sorting UI changed"):
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-en.prc - English
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-de.prc - German
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-pt.prc - Portuguese
> ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.tar.gz - Source Code
> 
> I've changed the screen used for sorting so that it is a bit easier to
> use. The change I want some comments on is the way in which rows are
> deleted and added now. You click on the down arrow on the left and get a
> little menu letting you select what to do.
> 
> Question: Should I make this behavior the default on the list views screen
> and the design screen?

I'm slightly confused about this.  (I didn't try the previous test
release.)  The view editor seems OK to me, though the screen where you
choose a view to edit is awkward because of the nonstandard placement
and functionality of the buttons (`done' should be at the bottom, and
delete should require confirmation, etc.)

However in this test release the sort editor is a bit strange: there's
a name field on the screen which appears to have no effect.  Perhaps
I've misunderstood it, or it's just half finished (it is a testing
release after all).

I think the database design screen is somewhat better than the view
design screen.  Clearly the sort, database design and view design
screens need to be similar.  If I can be so bold as to make a
suggestion: how about making them work a bit more like the todo list
application ?

Ie, like the current database design screen but, rename the button
`Ins' with `New' and have it just insert a new item either at the end,
or after your current field if you're in one.  `Delete' would just
delete the selected item (ie, the one with the cursor in it).  You
still need an better way to change the order, but that's more easily
done with `Up' and `Down' drag buttons which move the current item
about.  If you did it that way you wouldn't need to have that
confusing and awkward sub-menu which pops up when you want to add a
field.

Perhaps other people will disagree with me :-).

Ian.

[pilot-db-list] sorting UI changed

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

ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-en.prc - English
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-de.prc - German
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-pt.prc - Portuguese
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.tar.gz - Source Code

I've changed the screen used for sorting so that it is a bit easier to
use. The change I want some comments on is the way in which rows are
deleted and added now. You click on the down arrow on the left and get a
little menu letting you select what to do.

Question: Should I make this behavior the default on the list views screen
and the design screen?

[pilot-db-list] Re: Relational DB

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

On Fri, 27 Oct 2000, Larry K. Turner wrote:

> I think if yon incorporated LinkMaster's Link Container abilities into
> DB; you could achieve a limited ability to relating data from one
> database to another.  What do you or any other list members think? 

That might help somewhat. However, I'd probably roll my own style of
"link" which refered to another database via DB's internal data source
API since LinkMaster is not supported by everything.

-Tom

[pilot-db-list] Relational DB

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

Tom

I think if yon incorporated LinkMaster's Link Container abilities into DB; you could achieve a limited ability to relating data from one database to another.  What do you or any other list members think?

Larry

[pilot-db-list] yet another test release

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

ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-en.prc - English
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-pt.prc - Portuguese
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.tar.gz - Source Code

Changes:

* Portuguese and German translation files updated. New German strings
still need to be translated. Two people had sent in a French translation. 
Do you want me to update the French file so you can translate the new
strings? 

* MobileDB support. DB can now read/write/create databases in MobileDB
format. It can also convert to/from this format into its own native format
using the "Duplicate" context menu option.

-Tom

[pilot-db-list] palm-db-tools version 0.3.0

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

I've released version 0.3.0 of the palm-db-tools package which provides
the conversion utilities for use on the desktop. Go to the home page for
downloads:

  http://palm-db-tools.sourceforge.net/

Grab the ZIP file for Windows binaries and the .tar.gz file with the
source code for UNIX systems.

-Tom

[pilot-db-list] test release

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

ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.prc    - English
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest-de.prc - German
ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.tar.gz - Source Code

I'm going to add some help screens, ask for translation updates, and then
release 0.3.1.

Changes:

* Portuguese translation from Pedro Pessoa <ped...@li...>

* You can now edit and use multiple list views from within DB. To use,
chose "Display..." from the "Options" menu in the list view. The resulting
dialog lets you choose a defined view to show.

To edit, choose "Edit list views..." from the "Options" menu in the list
view. A screen containing all the active list views will appear. To edit a
list view, tap the name and then "Edit". To create a new one, tap "New".
To delete a view, tap the name and then "Delete".

Also, the list view editor will not allow you reorder fields now if the
database format does not support it. That way, you can only change the
field widths for DB 0.2.x.

* Fixed a bug that Harald Hanche-Olsen <ha...@ma...> found and
posted to this list. The bug was that when creating a new record, the
"Delete" button was active and worked ... on existing records. The button
is now disabled for new records as it should be.

* Modified the sorting code into its temporary final form.

Tom Dyas                     Email: td...@va...
Professional Services
VA Linux Systems

Re: [pilot-db-list] Design Doc?

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

On Mon, 16 Oct 2000, Scott Wallace wrote:

> Is there a disign doc, or any sort of roadmap for the future of DB?  I was 
> going to poke around in the code a bit in the next few weeks and was hoping 
> for a bit of high-level description and motivation for how things are/should 
> be done.

There is the TODO document but that is more of a wishlist and probably
doesn't have everything.

As for motiviation for how things are done, I've been trying to avoid
specific code and rather create abstraction layers like the "data source"
layer and the grid widget. It makes for much cleaner code. If you have
specific things, I can help with what types of implementations would be
good.

[pilot-db-list] Design Doc?

[Scott W. <sco...@ho...>]

Is there a disign doc, or any sort of roadmap for the future of DB?  I was 
going to poke around in the code a bit in the next few weeks and was hoping 
for a bit of high-level description and motivation for how things are/should 
be done.

  -Scott
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

[pilot-db-list] conversion utilities

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

Is there enough interest in the conversion utilities alone to warrant a
seperate mailing list?

Does anyone want to help develop the conversion utilities? (I've put the
current code incl. the Win32 changes into CVS on SourceForge so it should
really simple if anyone wants to help.)

Re: [pilot-db-list] is it now possible to....

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

On Sat, 14 Oct 2000, Timothy Laswell wrote:

> >had the format for the command.  Or the following example.
> ...
> >view "Ages" "Name" 120 "Age" 40
> 
> So are the pc tools the only way to create a new view?  It looks as if you
> can select from 1 of many views (the view name in the upper right
> corner of the view editor has a drop down arrow) but how do you create a
> new separate view?  Can you have more than one view on a database?  Can it
> be done on the Palm?

My test code lets you select and create multiple list views. However, I
still need to clean up a bunch of code ubut I was working on the
conversion utilities which are the current priority.

Tom Dyas                     Email: td...@va...
Professional Services
VA Linux Systems

Re: [pilot-db-list] is it now possible to....

[Timothy L. <tla...@er...>]

>had the format for the command.  Or the following example.
...
>view "Ages" "Name" 120 "Age" 40

So are the pc tools the only way to create a new view?  It looks as if you
can select from 1 of many views (the view name in the upper right
corner of the view editor has a drop down arrow) but how do you create a
new separate view?  Can you have more than one view on a database?  Can it
be done on the Palm?

Tim Laswell - Columbia MD

[pilot-db-list] windows conversion utilities

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

I got pre2 to compile under Windows with some minor modifications. Get:

ftp://palm-db-tools.sourceforge.net/pub/palm-db-tools/dbtools_0_3_0_pre2.zip

This contains Win32 binaries for the utiltiies. The mods I made will be in
pre3.

Tom Dyas                     Email: td...@va...
Professional Services
VA Linux Systems

[pilot-db-list] (no subject)

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

ftp://palm-db-tools.sourceforge.net/pub/palm-db-tools/palm-db-tools-0.3.0-pre2.tar.gz

I've cleaned up the source code so there are no warnings. Also, some
cleanups to get Win32 to work. Will reboot into Windows to try building it
there. The project files are slightly are out of whack but do reflect the
new strucuture. 

Tom Dyas                     Email: td...@va...
Professional Services
VA Linux Systems

RE: [pilot-db-list] is it now possible to....

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

On Wed, 11 Oct 2000, Bruce Fisher wrote:

> I read the manual.txt and searched around but I didn't find anything to tell
> me the format of the "view" command.

I haven't updated the manual.txt yet. My announcement email to the list
had the format for the command. Or the following example:

field "Name" string
field "Address" string
field "Age" integer
view "Ages" "Name" 120 "Age" 40

Re: [pilot-db-list] alpha of new conversion utilities

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

On Tue, 10 Oct 2000, Hal DeVore wrote:

> You've got a bit of work to do before they'll compile under
> Windoze.  First problem I had was that VC++ 6 doesn't seem to
> deal with *.dsw and *.dsp files that don't have carriage
> returns.  It'll handle source files with only linefeed for a
> lineend but doesn't seem to like it in "his own" files.

And when it comes time for me to compile under Windows, I'll take care of
the CRLF stuff just as I did for the 0.2.1 release.

> Once I filtered all the files under your win32 dir to add the
> CRs, I found that the project files don't match the layout of the
> source files.

That's because those are the project files for the 0.2.1 release. :) 
"Working on Windows" means I have to recreate all the project files and
such ... 

Re: [pilot-db-list] alpha of new conversion utilities

[Hal D. <hd...@bm...>]

>>>>> On Mon, 9 Oct 2000, "Tom" == Tom Dyas wrote:

  Tom> The source code above is only useful for UNIX users. I
  Tom> haven't even tried to compile the utilities under Windows
  Tom> yet (but plan to).  You can compile under UNIX by doing:

You've got a bit of work to do before they'll compile under
Windoze.  First problem I had was that VC++ 6 doesn't seem to
deal with *.dsw and *.dsp files that don't have carriage
returns.  It'll handle source files with only linefeed for a
lineend but doesn't seem to like it in "his own" files.

Once I filtered all the files under your win32 dir to add the
CRs, I found that the project files don't match the layout of the
source files.

I haven't done anything more with the Windows side.
I'm compiling the utilities on Linux now.

--Hal