pilot-db-list

[pilot-db-list] Scripts for Calculated type: documentation and a question

[Elias B. <eb...@ca...>]

Hi,

I just started using Pilot-DB. Coming from a ThinkDb background.

I am looking in the documentation for the scripting that can be used =
with 'calculated' types but cannot find it. Please provide pointers to =
existing descriptions of how this works.

Specifically I want to get the difference between 2 DATE fields in a =
record as a DATE result.

Also, is there any notion of getting the date of TODAY or of the =
entry/last-modification of a given record, the time of NOW, the index of =
the current record in the DB?

thank you kindly for your attention



Elias Biris, Member of Technical Staff
Cadence Design Systems Ltd, SOC Design Centre
1 The Alba Campus      |TEL: +44 (0)1506595036
Livingston, EH54 7HH   |FAX: +44 (0)1506595959

Re: [pilot-db-list] Plugins corrections

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

From: marc-chalain <mar...@wa...>

> "Larry W. Virden" wrote:
> > 
> > From: marc-chalain <mar...@wa...>
> > >i corrected the plugins:
> > 1. How does one get these?
> db-ColorSelect.prc: set the colors of the ListView for GrayScale and
> Color Device

Sorry - I used the wrong English words.  Let me try again - from what
web site and download file will I find the corrected plugins.


> > 2. If there are hardware or software restrictions on using particular
> > plugins (for example, if adding in a vfs plugin will crash on particular
> > hardware or operating system versions) PLEASE document this in the readme.
> There is no restriction but some plugins could be unusefull.

Okay - I just mean that, if at any time there is a plugin that, say, requires
a Color Palm, or a Clie, or version 4.1 of the OS, I hope that this will
be documented so that users don't install a plugin that causes a problem
because they didn't know that it would.

> > 3. Anyone working on an update to the palm-tools source code ?  As a long
> > term user of DB, I hope that a new version of DB is not released until
> > the palm-tools for creating DB databases are updated.
> If you want to wait.(not before a month and i didn't receive help then
> there will be not Windows or/and Mac distributions)

I am not worried about a Windows or Mac version myself - I am just awaiting
updated source code for the palm-tools so that I can compile them on my
SPARC Solaris.
-- 
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] Re: db 0.3.4 beta 9

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

	Hello all.


	Didn't get a lot of time to test beta 9 until tonight.
	Sorry, I have bought a new machine (old for all, new
for me :-) and had a hard time to get all I she to do for
me with linux.

	o I can't no more modifiy a list : when I add or
remove entry, the prog tells me it must rebuild, ok, then
displays a message stating that an error occured, no
modififications made (exact message : "An error was
encountered during rebuild. No changes have been made").
I'm pretty sure I saw that in beta8 but only when
removing entries.
	o Strange : the same happen when I try to add
a field in an existing database.

	I just installed beta9 over the beta8 I did
install over the beta6 (I think) without first
removing (I use filez for removing just one file) the
existing version.

	I can do more tests if you need.

	Fab.
 	

[pilot-db-list] Re: db 0.3.4 beta 9

[marc-chalain <mar...@wa...>]

Alexey Zhukov wrote:
> 
> Hello marc-chalain,
> 
> Friday, March 01, 2002, 1:07:09 PM, you wrote:
> 
> mc>  1) duplicate database crashs when it contained a Link field.
>     OK!
> mc>  2) the note title crash when the use "first line for title" box is
> mc> cheked.
>     Some as in yesterday's version: OK on device, corrupted chunk on
> emulator.

I corrected this bug only on the beta 9 distributed the 01 march

> mc>  3) the object not in form wehn the database is opened in readonly mode.
>      OK!
> 
>      That's couple other "undocumented features":
> 
> 1. I made base1 with field1 and field 2
>    I made base2 with link1 (link to field1 of base1) and linked2
>       (linked to field1 of base1).
>    I made few records in base1.
>    After that I created new record in base2:
>          selected field in link1
>          link2 cann't be modyfied (it's right).
>    When I stored record, link2 left blank. (!!!)
>    And only when i opened this record (fo reading) link2 was updated,
>      and on leave I was asked to save modified (!!!) record

i will see that but i'm not sure to "change" (not "correct", its a
feature not a bug for me) this. about the box to save the record, it's
normal. DB update all links at the opening (it's for that you can see
the modification) but i can be sure that you want to save the data.

> 2. (Handera related)In rotated mode forms for Edit list views,
> show/modify notes and link selection cann't be shown. Obvious it will
> be until these forms become resizible.

Not on this release. the next one.

[pilot-db-list] Mac Desktop transfer

[Miller (Michael) <mm...@pe...>]

A note on the Mac desktop:
I was able to verify the problem with the Mac Desktop Palm client 2.6.3 =
when trying to transfer the database back to the palm. MobileDB databases =
work fine, but DB's databases don't. The client seems to damage the file =
in some way.=20

I use Virtual PC running Windows98 on my Mac laptop running OS X and OS 9. =
I was able to boot in OS 9 and run VirtualPC and sync my Palm with the =
Windows desktop client and the database transfered fine. I hope that the =
new version of the desktop client (now in beta) for the Mac will fix this =
problem.

Michael Miller

[pilot-db-list] problems with backup (Mac?)

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

I had another look at the previous mails and found out that it might be a
problem with the mac-desktop (see Michael C. Miller 02/22/2002=A005:29:49). I
still use Mac OS 8.6.

DB just fits my needs, so I hope the problem can be fixed...

Jan Ruitman

[pilot-db-list] <Kein Betreff>

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

I=B4m using DB (0.3.4beta5as) on a visor neo and have difficulties when I try
installing a new database or even a backup of my own files. It is not
possible to open the databases on the handheld also they appear in the list
view. Are there any solutions for this problem?

with best regards

Jan Ruitman

Re: [pilot-db-list] Re: Mobile-DB, various

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

> What's it more interesting that i spend my time on palm-db-tools (with a
> new gui) or on MobileDB?
> The current MobileDB plugin doesn't support new fields.

	My point is other base formats plugins should only support
what is necessary to convert bases to DB3 format. It's too much
work to maintain all those formats. If someone want to maintain
them, he will probably be welcomed in the dev team, won't he ? :-)

	Fab.

Re: [pilot-db-list] Plugins corrections

[marc-chalain <mar...@wa...>]

"Larry W. Virden" wrote:
> 
> From: marc-chalain <mar...@wa...>
> 
> >i corrected the plugins:
> > db-ColorSelect.prc
> > db-informations.prc
> > db-DB3vfs.prc
> 
> 1. How does one get these?
db-ColorSelect.prc: set the colors of the ListView for GrayScale and
Color Device
db-informations.prc: display records number and database size (more a
sample than a real plugin)
db-DB3vfs.prc: open read/write DB databases on Card extension
(PALM/Launcher directory)

> 2. If there are hardware or software restrictions on using particular
> plugins (for example, if adding in a vfs plugin will crash on particular
> hardware or operating system versions) PLEASE document this in the readme.
There is no restriction but some plugins could be unusefull.

> 3. Anyone working on an update to the palm-tools source code ?  As a long
> term user of DB, I hope that a new version of DB is not released until
> the palm-tools for creating DB databases are updated.
If you want to wait.(not before a month and i didn't receive help then
there will be not Windows or/and Mac distributions)

Re: [pilot-db-list] form.c, line:1728, object not in form

[marc-chalain <mar...@wa...>]

Wayne Dean wrote:
> 
> Yes, I use db-en-light.prc, as I have a Palm III & prefer the b/w
> display. I did get an error when I installed the db-en after the hot-
> sync. I should also mention that I am running Mandrake/JPilot on my
> desktop (JPilot uses pilot-xfer, correct?). & I did try deleting all
> things pertaining to pilot-db & then reinstalling beta 8, but the
> problem persisted.
> 
> The db-en-light version also had some other interesting effects:
> 
> 1) All the categories of preexisting db tables were changed
> to "unfiled".
> 
> 2) The 3rd-party tables you offer for download also cannot be read by
> the new version.
> 
> 3) The http://prdownloads.sourceforge.net/pilot-db/db-MobileDB.prc
> plugin doesn't work. I assumed that the plugins under 1.0.0 were for
> the beta 8, as opposed to the 0.3.2beta2 plugins. I attempted
> rescanning for databases, but my mobiledb files didn't appear.
> 
> 4) I tried the 0.3.2 db-tools to export one of my existing tables to
> csv & back to pdb, hoping that would make it readable by beta 8 without
> the crashing error, but to no avail.
> 
> But . . . I could reinstall beta 1 over beta 8 & resume work on my
> existing files. But I really want to make use of the new field types,
> as they are quite exciting. Thank you for all your work on this
> wonderful program.
> 

The light version doesn't support Plugins.
I will send you directly a new light version soon.

[pilot-db-list] Re: Mobile-DB, various

[marc-chalain <mar...@wa...>]

Hans Ajiet Holtkamp wrote:
> 
> Dear Marc,
> 
> Since I always get an error on installing the Mobile-DB Plug-In
> I do not know if the new Mobile-DB Fields are supported.
> 
> Please let me know,
> 
> If the new Mobile-DB Field-Types are supported,
> 
> if not,
> 
> please let me know when you, or scott plan to support these fields.
> 
> Actually the only reason I am asking is because The PC-Mobile-DB is
> the only windows version which I can use to create databases.
> 
> That is why I am very excited about your new windows-DB-Tools program!
> 
> I am sorry that I have not yet found the time to make the changes in
> the web-site. I do not have a new palm yet (only one which I sometimes
> borrow).
> 
> As soon as I get a new one, I'll become active again, I promise!
> 
> Thanks for all your work on Pilot-DB (and the new tool), once again!
> 
> Hans.

What's it more interesting that i spend my time on palm-db-tools (with a
new gui) or on MobileDB?

The current MobileDB plugin doesn't support new fields.

Re: [pilot-db-list] form.c, line:1728, object not in form

[Wayne D. <way...@mo...>]

Yes, I use db-en-light.prc, as I have a Palm III & prefer the b/w 
display. I did get an error when I installed the db-en after the hot-
sync. I should also mention that I am running Mandrake/JPilot on my 
desktop (JPilot uses pilot-xfer, correct?). & I did try deleting all 
things pertaining to pilot-db & then reinstalling beta 8, but the 
problem persisted.

The db-en-light version also had some other interesting effects:

1) All the categories of preexisting db tables were changed 
to "unfiled".

2) The 3rd-party tables you offer for download also cannot be read by 
the new version.

3) The http://prdownloads.sourceforge.net/pilot-db/db-MobileDB.prc 
plugin doesn't work. I assumed that the plugins under 1.0.0 were for 
the beta 8, as opposed to the 0.3.2beta2 plugins. I attempted 
rescanning for databases, but my mobiledb files didn't appear.

4) I tried the 0.3.2 db-tools to export one of my existing tables to 
csv & back to pdb, hoping that would make it readable by beta 8 without 
the crashing error, but to no avail.

But . . . I could reinstall beta 1 over beta 8 & resume work on my 
existing files. But I really want to make use of the new field types, 
as they are quite exciting. Thank you for all your work on this 
wonderful program.

----- Original Message -----
From: marc-chalain <mar...@wa...>
Date: Wednesday, February 27, 2002 9:20 am
Subject: Re: [pilot-db-list] form.c, line:1728, object not in form

> Wayne Dean wrote:
> > 
> > I upgraded from beta 1 to beta 8 & tried opening
> > an older db file, & got that fatal alert.
> 
> Do you use db-en-light.prc? because there is this bug in the beta8
> If you use db-en.prc then there was a trouble during the hotsync (not
> come from us but to have short link, Palm doesn't update 
> everything) you
> must delete db on your device (backup your databases before, or 
> use a
> tool like filez). Another way is to not use the Hotsync to install an
> application but a tool like "Pilot Install" or pilot-xfer which update
> everything.
> 

[pilot-db-list] (no subject)

[Sandro P. <spe...@us...>]

Re: [pilot-db-list] Script Documentation

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

From: Scott Wallace <swa...@my...>
> The current script documentation can always be found in the cvs 
> repository, in the file scripts.txt:
> 
> http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/pilot-db/db/docs/

Perhaps the latest version of the doc could be included in the release,
with a URL in it pointing to where to find the very latest version?
-- 
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] Plugins corrections

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

From: marc-chalain <mar...@wa...>

>i corrected the plugins:
> db-ColorSelect.prc
> db-informations.prc
> db-DB3vfs.prc

1. How does one get these?
2. If there are hardware or software restrictions on using particular 
plugins (for example, if adding in a vfs plugin will crash on particular
hardware or operating system versions) PLEASE document this in the readme.
3. Anyone working on an update to the palm-tools source code ?  As a long
term user of DB, I hope that a new version of DB is not released until
the palm-tools for creating DB databases are updated.
-- 
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] Beta 8

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

I notice that in the pilot-db beta 8 release (and it is probably true for
older ones) that the readme refers people to 
  http://palm-db-tools.sourceforge.net/
but that is just a redirect back to http://pilot-db.sourceforge.net/ .
Seems like if we are going to merge the two projects we should just
refer to the latter.
-- 
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] form.c, line:1728, object not in form

[Wayne D. <wd...@mo...>]

I upgraded from beta 1 to beta 8 & tried opening
an older db file, & got that fatal alert.

[pilot-db-list] Problems with colors

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

Hello,
I'm using palm db 0.3.4beta8cas on a palm 3xe. When I start a db, I must
push the contrast to the limit. At first I think it was a problem of the
palm, but by other programms the contrast is ok. I had installed the plugin
for the colours, and I switch all colours to black or white, but it doesn't
bring any help. Is it possible, to release a black and white version, like
the old 0.3.x releases?

With best regards

Malte Kaldewey

Re: [pilot-db-list] Float column margin

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

On Mon, 25 Feb 2002, marc-chalain wrote:
> Scott Wallace wrote:
> > > > possible :-) Also, any chance the number of digits can be set per database
> > > > or even per column? I could definitely use varying precision in some
> > > > completely unrelated databases that I have.
> >
> >         I will think about working this into the code in the future, but
> > not for this release.  It would be too hard at this point.

I agree, since I would like to see the current beta get stable. Is there
any chance of reducing the space and/or adding a variable space menu item
sooner? This is actually of greater interest to me right now.

Mike

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

Re: [pilot-db-list] Float column margin

[marc-chalain <mar...@wa...>]

Scott Wallace wrote:
> 
> On Fri, 22 Feb 2002, Fab wrote:
> 
> > > possible :-) Also, any chance the number of digits can be set per database
> > > or even per column? I could definitely use varying precision in some
> > > completely unrelated databases that I have.
> >
> >       I second this.
> >       How borrying are users :-)))))))))))
> >
> >       Fab.
> 
>         I will think about working this into the code in the future, but
> not for this release.  It would be too hard at this point.
> 
>         -Scott

I agree with Scott, we will not add new feature for this version. I
thought to make the release at 01/2002 and we are at the end of 02/2002.
We must freeze the features and correct the bugs.

[pilot-db-list] Script Documentation

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

The current script documentation can always be found in the cvs 
repository, in the file scripts.txt:

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/pilot-db/db/docs/


Hans, could we put a note in the manual about this?

	-Scott

Re: [pilot-db-list] More beta 8 buglets

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

On Fri, 22 Feb 2002, Mike Ressler wrote:

> On Fri, 22 Feb 2002, Scott Wallace wrote:
> > > 4) The floating type seems to be padded by several spaces on the right
> > > hand side. I.e. when adjusting the view, there is always about 10 pixels
> > > of white space after the 1 decimal place I set. If I attempt to squeeze
> > > the white space, then numbers change to "..." indicating it doesn't fit.
> >
> > Yes, this is true.  There is a 10 pixel margin on the right side of a
> > float column.  If there is no margin, what happens is that the float is
> > directly adjacent to the value in the next column (since most columns are
> > left justified) ...
> > you could make the margin disappear as the the column becomes increasingly
> > full.  But this requires calculating the max width overall columns, which
> > is too slow.  So instead, I just use a constant value.
> 
> Is it that slow? I guess the real question is how often the value would
> have to be recalculated. If it can be calculated only when the DB is
> opened, it should be tolerable. (You may then have to close and reopen the
> database to get it to update correctly.) I would think that calculating
> the maximum width of one of the elements, right justifying each element
> within this box width, then _left_ justifying boxes within the column
> based on the width given in the list view would be the best way to attack
> this.

Yes, you could calculate the value when opening and then update it each 
time a record was added, deleted or removed, but currently, there is no 
support to do such a thing, and it would mean a fairly significant 
internal change, that I would rather avoid now that we are so close to 
release.

In the meantime I'll lower the padding from 10 to 4 pixels...

	-Scott

Re: [pilot-db-list] Float column margin

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

On Fri, 22 Feb 2002, Fab wrote:

> > possible :-) Also, any chance the number of digits can be set per database
> > or even per column? I could definitely use varying precision in some
> > completely unrelated databases that I have.
> 
> 	I second this.
> 	How borrying are users :-)))))))))))
> 
> 	Fab.


	I will think about working this into the code in the future, but 
not for this release.  It would be too hard at this point.

	-Scott

Re: [pilot-db-list] More beta 8 buglets

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

On Fri, 22 Feb 2002, Tom Dyas wrote:
> On Friday 22 February 2002 01:49 am, Mike Ressler wrote:
>
> > 5) it is impossible to edit list views on DB 2.x databases. When I attempt
> > to do so, no "New" button appears, and there is no old view to click on to
> > choose "Edit".
>
> The DB 0.2.x format never had any support for multiple list views. It just
> had a place for the field widths.

Ah, I had forgotten this.

> You can just use the "duplicate" option on
> the chooser screen and change the database format to the current format.

This is what I did to get around it. No more DB2s laying about :-)

Mike

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

Re: [pilot-db-list] More beta 8 buglets

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

On Friday 22 February 2002 01:49 am, Mike Ressler wrote:

> 5) it is impossible to edit list views on DB 2.x databases. When I attempt
> to do so, no "New" button appears, and there is no old view to click on to
> choose "Edit".

The DB 0.2.x format never had any support for multiple list views. It just 
had a place for the field widths. You can just use the "duplicate" option on 
the chooser screen and change the database format to the current format.