pilot-db-list

Re: [pilot-db-list] Another ideas

[Martin B. <mar...@pa...>]

On St, 2003-03-26 at 18:07, Craig Bowers wrote: 

> I can confirm the presence of both issues for me with pilot-db 1.1b2 on
> OS4.1

I am very sorry ... I didn't report versions: 
OS: Handera PalmOS 3.5.3A29 (the most up-to-date version) 
PilotDB: 1.1.0 B2 (but About box shows 1.1.0B1) downloaded from
sourceforge.net.

Copy&Paste doesn't work even in edit mode. 
Martin 

-- 
Martin Bodlak, Ostrava, CR
---> www.palmknihy.cz <---
mar...@pa...

Re: [pilot-db-list] Another ideas

[Craig B. <sys...@ca...>]

I can confirm the presence of both issues for me with pilot-db 1.1b2 on
OS4.1

Re: [pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Another_ideas?=

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

On Wed, 26 Mar 2003, mar...@la... wrote:

> If the Copy&Paste doesn't work, it's an error from us.
> For the memoexport i will see that asap.


I believe I fixed this in the 1.1, its basically the same problem as that 
correction I sent you for the report plugin.  Because of the way the memo 
dialog gets opened, the events are handled in an abnormal way, so I think 
I needed to add an explicit call to SysHandleEvent.


	-Scott

> 
> ---------- Debut du message initial -----------
> 
> De     : pil...@li...
> A      : pil...@li...
> Copies : 
> Date   : 25 Mar 2003 22:12:15 +0100
> Objet  : [pilot-db-list] Another ideas
> 
> Hello!
> 
> I think I have more ideas for Pilot-DB improvement. I realized
> them
> while trying to change my database structure...
> 
> 1- It would be nice if it is possible to copy textual data
> from the note
> field. I would like to split one note field to more string
> fields and I
> can't copy&paste...
> 
> 2- If I export the record with note field to memopad, the
> field is not
> exported. I know the record can be bigger than memopad note
> size, but it
> would help not only while redesigning the database.
> 
> Thanks for good work!
> Martin
> 
> 

-- 

Re: [pilot-db-list] DB Format

[Norman W. <nd...@nw...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

|> A lot of developpers ask us the update of the Format.txt file
|> which describes the format of the database of Pilot-DB.
|> I join here the new file, that you will be able to find with
|> the next releases.
|> 
|> Send us your questions or the parts to update.

Ok, I'm looking at the appinfo from my test database and it looks like
this:

appinfo  :
00.00.00.09.00.00.00.32.73.74.72.69.6E.67.00.62
  .  .  .  .  .  .  . 2. s. t. r. i. n. g.  . b
6F.6F.6C.00.69.6E.74.00.66.6C.6F.61.74.00.64.61
 o. o. l.  . i. n. t.  . f. l. o. a. t.  . d. a
74.65.00.74.69.6D.65.00.6C.69.73.74.31.00.6C.69
 t. e.  . t. i. m. e.  . l. i. s. t. 1.  . l. i
6E.6B.00.6C.69.6E.6B.65.64.00.00.01.00.12.00.00
 n. k.  . l. i. n. k. e. d.  .  .  .  .  .  .  
00.01.00.02.00.08.00.03.00.04.00.06.00.07.00.0A
  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  
00.02.00.10.00.06.00.03.0C.00.6F.6E.65.00.74.77
  .  .  .  .  .  .  .  .  .  . o. n. e.  . t. w
6F.00.33.00.00.02.00.24.00.07.4D.6F.76.69.65.73
 o.  . 3.  .  .  .  . $.  .  . M. o. v. i. e. s
00.2E.00.00.00.00.00.00.00.00.00.00.00.00.00.00
  . ..  .  .  .  .  .  .  .  .  .  .  .  .  .  
00.00.00.00.00.00.00.00.00.00.00.03.00.41.00.04
  .  .  .  .  .  .  .  .  .  .  .  .  . A.  .  
00.00.00.00.00.80.00.02.00.00
  .  .  .  .  .  .  .  .  .  

Going through the header, I find:

  flags    : 0
  numChunks: 9

Ok so far.

  chunk 0
          0
          50
          string,bool,int,float,date,time,list1,link,linked

The field names...

  chunk 1
          1
          18
          0,1,2,8,3,4,6,7,10

The field types...

  chunk 2
          2
          16
          6[6], 3, 3072
                  one,two,3

The list of values for field 6...

  chunk 3
          2
          36
          7[7], 76694d6f, 25971


Ok, chunk 3 is of type 2 and it's for field number 7 which is type 7
(coincidentally). Type 7 is a link, so this chunk should contain:

  Link Field Type:
    UInt16 fieldNum
    UInt32 recordID (of the ChooserDB record corresponding to the database.)
    UInt16 filedNum (of the record to display.)

But it's length is 36 which seems really odd. And the actual data in the field

  00.02.00.24.00.07.4D.6F.76.69.65.73
    .  .  . $.  .  . M. o. v. i. e. s
  00.2E.00.00.00.00.00.00.00.00.00.00.00.00.00.00
    . ..  .  .  .  .  .  .  .  .  .  .  .  .  .  

doesn't look like it corresponds. It looks more like the name of the linked
database is in there.

                                        Be seeing you,
                                          norm

- -- 
Norman Walsh <nd...@nw...> | It is not failure of others to
http://nwalsh.com/            | appreciate your abilities that should
                              | trouble you, but rather your failure to
                              | appreciate theirs.--Confucius
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.7 <http://mailcrypt.sourceforge.net/>

iD8DBQE+gbSDOyltUcwYWjsRAmRRAJ9QqDUl7G3koVqayvqmtH0t2dWHQwCfegBy
cYBnaCnqgNSt0JEnBxGQL2g=
=RQnp
-----END PGP SIGNATURE-----

Re: [pilot-db-list] Another ideas

[Thomas R. <tr...@or...>]

>=20
> 1- It would be nice if it is possible to copy textual data from the not=
e
> field. I would like to split one note field to more string fields and I
> can't copy&paste...
>=20
Hi,

Copy from note fields works fine here on my cli=E9 SL10 with DB 1.0.4. Bu=
t=20
you can not cut or paste in the note field if you are not in edit mode:=20
you must click the fifth icon at the bottom of the record screen before=20
you edit a note field.
Hope this helps.

Thomas

[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Another_ideas?=

[=?iso-8859-1?Q?<mar...@la...>]

If the Copy&Paste doesn't work, it's an error from us.=0D=0AFor the memoe=
xport i will see that asap.=0D=0A=0D=0A---------- Debut du message initia=
l -----------=0D=0A=0D=0ADe     : pil...@li...urceforge.n=
et=0D=0AA      : pil...@li...=0D=0ACopies : =0D=0A=
Date   : 25 Mar 2003 22:12:15 +0100=0D=0AObjet  : [pilot-db-list] Another=
 ideas=0D=0A=0D=0AHello!=0D=0A=0D=0AI think I have more ideas for Pilot-D=
B improvement. I realized=0D=0Athem=0D=0Awhile trying to change my databa=
se structure...=0D=0A=0D=0A1- It would be nice if it is possible to copy =
textual data=0D=0Afrom the note=0D=0Afield. I would like to split one not=
e field to more string=0D=0Afields and I=0D=0Acan't copy&paste...=0D=0A=0D=
=0A2- If I export the record with note field to memopad, the=0D=0Afield i=
s not=0D=0Aexported. I know the record can be bigger than memopad note=0D=
=0Asize, but it=0D=0Awould help not only while redesigning the database.=0D=
=0A=0D=0AThanks for good work!=0D=0AMartin=0D=0A=0D=0A-- =0D=0AMartin Bod=
lak, Ostrava, Czech Republic=0D=0Ahttp://bodlak.palmknihy.cz, bodlak@emai=
l.cz=0D=0A---=0D=0ANavstivte take http://www.palmknihy.cz/=0D=0A=0D=0A=0D=
=0A=0D=0A=0D=0A-------------------------------------------------------=0D=
=0AThis SF.net email is sponsored by:=0D=0AThe Definitive IT and Networki=
ng Event. Be There!=0D=0ANetWorld+Interop Las Vegas 2003 -- Register toda=
y!=0D=0Ahttp://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en=0D=0A__=
_____________________________________________=0D=0APilot-db-list mailing =
list=0D=0AP...@li...=0D=0Ahttps://lists.sourcefo=
rge.net/lists/listinfo/pilot-db-list=0D=0A=0A=0AAcc=E9dez au courrier =E9=
lectronique de La Poste : www.laposte.net ; =0A3615 LAPOSTENET (0,34=80/m=
n) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

[pilot-db-list] Another ideas

[Martin B. <bo...@em...>]

Hello!

I think I have more ideas for Pilot-DB improvement. I realized them
while trying to change my database structure...

1- It would be nice if it is possible to copy textual data from the note
field. I would like to split one note field to more string fields and I
can't copy&paste...

2- If I export the record with note field to memopad, the field is not
exported. I know the record can be bigger than memopad note size, but it
would help not only while redesigning the database.

Thanks for good work!
Martin

-- 
Martin Bodlak, Ostrava, Czech Republic
http://bodlak.palmknihy.cz, bo...@em...
---
Navstivte take http://www.palmknihy.cz/

[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Report_plug-in_issue?=

[=?iso-8859-1?Q?<mar...@la...>]

It could have a bug, but i don't know if it's possible to=0D=0Acorrect it=
.=0D=0AI will see.=0D=0ASalut,=0D=0AMarc.=0D=0A=0D=0A---------- Debut du =
message initial -----------=0D=0A=0D=0ADe     : pilot-db-list-admin@lists=
.sourceforge.net=0D=0AA      : <pil...@li...>=0D=0A=
Copies : <pil...@li...>=0D=0ADate   : Mon, 24 Mar =
2003 16:52:19 -0800=0D=0AObjet  : [pilot-db-list] Report plug-in issue=0D=
=0A=0D=0ANoticed today that the Report plug-in (possibly others?) is a=0D=
=0Amodal=0D=0Adialog, and it likely shouldn't be.=0D=0A=0D=0AWith the rep=
ort displaying:=0D=0AHardware buttons such as the power button are ignore=
d.  Worse, the=0D=0Aauto-off timer is ignored.=0D=0A=0D=0AOtherwise, stil=
l enjoying this version greatly.=0D=0A=0D=0A-Craig Bowers=0D=0A=0D=0A=0D=0A=
=0D=0A-------------------------------------------------------=0D=0AThis S=
F.net email is sponsored by:=0D=0AThe Definitive IT and Networking Event.=
 Be There!=0D=0ANetWorld+Interop Las Vegas 2003 -- Register today!=0D=0Ah=
ttp://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en=0D=0A___________=
____________________________________=0D=0APilot-db-list mailing list=0D=0A=
Pil...@li...=0D=0Ahttps://lists.sourceforge.net/li=
sts/listinfo/pilot-db-list=0D=0A=0A=0AAcc=E9dez au courrier =E9lectroniqu=
e de La Poste : www.laposte.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l=
 : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

[pilot-db-list] Report plug-in issue

[Craig B. <cr...@bo...>]

Noticed today that the Report plug-in (possibly others?) is a modal
dialog, and it likely shouldn't be.

With the report displaying:
Hardware buttons such as the power button are ignored.  Worse, the
auto-off timer is ignored.

Otherwise, still enjoying this version greatly.

-Craig Bowers

[pilot-db-list] Some ideas

[Martin B. <mar...@pa...>]

Hello, I am new to this list.

First, thank you for nice application. I use it not so heavily, e.g. for
cooking recipes :-) or radio stations available in my city... It is the
only free database available for my Handera! Wow!

Now I have some notes on versin 1.1.0b1, they are of low importance, but
someone have to tell it :-) - But hey, I still love the app! :-)))

1- On DB list screen, if I tap on database, not whole line is inverted,
baseline to bottom of the line stays "black text on white"

2- Most dialogs (e.g. Create Database) have bad dimensions - they have
no right and left edges. I think you set the position too left and width
too much. But as far as I can see starting curve of the dialog edge, I
think it is about 2-3 pixels position and double for the width.

3- The issue with VFS was mentioned in the posting a few hours ago :-) I
too think that there should be some directory like /Palm/Programs/DB or
PilotDB or whatever do you wish.

4- Filters - I think that "search" is not sufficient for filtering. One
would expect more operators, like "is not empty", "is not equal to", "is
equal to" etc. I hope for one of the next versions (well, I have to read
some todo documents...)

5- Database view, column width: I think the settings doesn't corelate
with visible view. Handera has 240px wide screen... and I think (should
I check it or is it known bug?) that the visible widths are different.

I would consider only relative values - i.e. if I set widths to 1, 5, 3
(3 columns), I will not get pixel widths of 1, 5 and 3, but columns wide
in ratio 1:5:3...

6- Record view: reading - I still can change values from "select one
value from the dropdown list" columns, although edit lines are read
only. I was very confused when I encountered this for the first time :-)

7- Recocr view: note fields - is it possible to show the whole note
field possibly with ruler on the side if the text is longer? It would be
of a good help for my cooking database, I keep cooking instructions in 
a note field and I have to click the note icon... This would be *very*
nice feature!

Anyway, Pilot-DB is very nice application - among the other things it is
one of apps with Handera support! Thanks a lot!

Martin

If you would like to have Czech translation, I would be happy to help
you prepare the translation...

-- 
Martin Bodlak, Ostrava, CR
---> www.palmknihy.cz <---
mar...@pa...

Re: [pilot-db-list] db 1.0.4

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

>>> Thomas Rohmer <tr...@or...> 03/21/03 09:16AM >>>
<snip>

>I also used for the first time the VFS pluggin and it seems that if I=20
>move a database it goes to the /Palm/Launcher directory. Is this=20
>something the user can change? If not I believe /Palm/Programs/DB would=20
>be more appropriate.

>Thomas


I agree that DataBases should go some place other that the /Palm/Launcher d=
irectory.  My is crammed so full of stuff from application or another it is=
 hard to keep up with what is who and who is what.  Or whatever...


Great application, Thanks
Larry




---------------------------------------------------------------------------=
----------------
Note:  Please update your email address for this user to reflect the=20
new MeadWestvaco Corporation.  MeadWestvaco employee=20
email addresses are in the format of  us...@Me...

This electronic message contains information from MeadWestvaco
Corporation or subsidiary companies, which may be confidential,
privileged or otherwise protected from disclosure.  The
information is intended to be used solely by the recipient(s)
named.  If you are not an intended recipient, be aware that
any review, disclosure, copying, distribution or use of this
transmission or its contents is prohibited.  If you have
received this transmission in error, please notify MeadWestvaco
immediately at pos...@Me....
---------------------------------------------------------------------------=
----------------


________________________________________________________________________
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20SkyScan
service._______________________________________________________________

Note:=20=20Please=20update=20your=20email=20address=20for=20this=20user=20=
to=20reflect=20the
new=20MeadWestvaco=20Corporation.=20=20MeadWestvaco=20employee=20email=20a=
ddresses
are=20in=20the=20format=20of=20...@Me...=20

This=20electronic=20message=20contains=20information=20from=20MeadWestvaco=

Corporation=20or=20subsidiary=20companies,=20which=20may=20be=20confidenti=
al,
privileged=20or=20otherwise=20protected=20from=20disclosure.=20=20The
information=20is=20intended=20to=20be=20used=20solely=20by=20the=20recipie=
nt(s)
named.=20=20If=20you=20are=20not=20an=20intended=20recipient,=20be=20aware=
=20that
any=20review,=20disclosure,=20copying,=20distribution=20or=20use=20of=20th=
is
transmission=20or=20its=20contents=20is=20prohibited.=20=20If=20you=20have=

received=20this=20transmission=20in=20error,=20please=20notify=20MeadWestv=
aco
immediately=20at=20p...@Me....
_______________________________________________________________________

[pilot-db-list] =?iso-8859-1?Q?Re:_[pilot-db-list]_db_1.0.4?=

[=?iso-8859-1?Q?<mar...@la...>]

For the chooser i see the trouble.=0D=0AFor the VFS, i will try to read t=
he both and save in=0D=0A/Palm/Programs/DB=0D=0A---------- Debut du messa=
ge initial -----------=0D=0A=0D=0ADe     : pil...@li...ur=
ceforge.net=0D=0AA      : ???=0D=0ACopies : pilot-db-list <pilot-db-list@=
lists.sourceforge.net>=0D=0ADate   : Fri, 21 Mar 2003 15:16:47 +0100=0D=0A=
Objet  : Re: [pilot-db-list] db 1.0.4=0D=0A=0D=0AThank you Marc for this =
new release.=0D=0AI'm using DB in HiRes and when I select the biggest fon=
t,=0D=0Athere is a =0D=0Aspace between each item in the chooser view. Now=
 in 1.0.4 this=0D=0Aseems to =0D=0Abe fixed if I open a database and then=
 close it and go back to=0D=0Athe =0D=0Achooser, but when I first start D=
B the chooser still has these=0D=0Aspaces =0D=0Abetween db names.=0D=0AI =
also used for the first time the VFS pluggin and it seems=0D=0Athat if I =
=0D=0Amove a database it goes to the /Palm/Launcher directory. Is this =0D=
=0Asomething the user can change? If not I believe=0D=0A/Palm/Programs/DB=
 would =0D=0Abe more appropriate.=0D=0A=0D=0AThomas=0D=0A=0D=0Amarc.chala=
in...@la... wrote:=0D=0A> Yes still a 1.0.x version, the last i hope.=0D=
=0A> New:=0D=0A>  1) OPENING FOR DATABASES FROM MACOS=0D=0A>  2) 5 ways k=
eypad support for Tungsten.=0D=0A>  3) new MobileDB plugins.=0D=0A>  4) b=
ug fix for the font selection.=0D=0A>  5) bug fix to access to the 4 reco=
rds of MobileDB databases.=0D=0A> =0D=0A> =0D=0A=0D=0A=0D=0A=0D=0A-------=
------------------------------------------------=0D=0AThis sf.net email i=
s sponsored by:ThinkGeek=0D=0AWelcome to geek heaven.=0D=0Ahttp://thinkge=
ek.com/sf=0D=0A_______________________________________________=0D=0APilot=
-db-list mailing list=0D=0AP...@li...=0D=0Ahttps=
://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A=0A=0AAcc=E9de=
z au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3615 LAPO=
STENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

Re: [pilot-db-list] db 1.0.4

[Thomas R. <tr...@or...>]

Thank you Marc for this new release.
I'm using DB in HiRes and when I select the biggest font, there is a 
space between each item in the chooser view. Now in 1.0.4 this seems to 
be fixed if I open a database and then close it and go back to the 
chooser, but when I first start DB the chooser still has these spaces 
between db names.
I also used for the first time the VFS pluggin and it seems that if I 
move a database it goes to the /Palm/Launcher directory. Is this 
something the user can change? If not I believe /Palm/Programs/DB would 
be more appropriate.

Thomas

mar...@la... wrote:
> Yes still a 1.0.x version, the last i hope.
> New:
>  1) OPENING FOR DATABASES FROM MACOS
>  2) 5 ways keypad support for Tungsten.
>  3) new MobileDB plugins.
>  4) bug fix for the font selection.
>  5) bug fix to access to the 4 records of MobileDB databases.
> 
> 

[pilot-db-list] =?iso-8859-1?Q?db_1.0.4?=

[=?iso-8859-1?Q?<mar...@la...>]

Yes still a 1.0.x version, the last i hope.=0D=0ANew:=0D=0A 1) OPENING FO=
R DATABASES FROM MACOS=0D=0A 2) 5 ways keypad support for Tungsten.=0D=0A=
 3) new MobileDB plugins.=0D=0A 4) bug fix for the font selection.=0D=0A =
5) bug fix to access to the 4 records of MobileDB databases.=0D=0A=0A=0AA=
cc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A36=
15 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

[pilot-db-list] Query for usage tips

[Craig B. <sys...@ca...>]

I'm sure enjoying the power and flexibility of the filters, sort, global
scripts, calculated fields, et al...

But a query for how others might be handling a few issues I'm struggling
with.

How might one filter out, or filter for records based on empty string
fields?  Other field types I have no problem with, but I'm not sure what
the pilot-db equivalent of null quotes would be.  And one can't seem to
be able to turn it into an integer with INT and query on a zero or
non-zero value, at least at this point with the intended functionality of
INT thus far.  Does anyone have filter examples for all records where a
string field is empty, and for all records where a string field is
non-empty?  I'd prefer not to have to resort to an extra boolean field
just for this purpose.  Or an extra non-visible string field than I could
perhaps do an SEQ comparison with.

Lastly, does anyone have any tricks for determining Field numbers quickly
for use in filters and sorts?  The only way I see is to pop into the Edit
Database Design.  If there isn't an easier way that I've been
over-looking, I wonder if it might be a useful header in the Sort popup
when a field column is tapped on, or maybe an addition to the Report
Plugin available from the same pop-up.

Am I missing the obvious in these?

[pilot-db-list] Re: Pilot-db-list digest, Vol 1 #625 - 2 msgs (Away)

[Pat P. <ppe...@nc...>]

I will be away until October 25th.  I will be checking my voice mail and =
email on a periodic basis.  For immediate assistance, please contact Kyle =
Williams @ kwi...@nc....

Thanks,
Pat=20

[pilot-db-list] dbsql updated again.

[Mike M. <mw...@mi...>]

To those few brave soles trying the dbsql tool, it's been udpated
again. It now handles bidirectional data movement for all field
types. You'll need to recreate your data tables and views with "-Dc".

To those who haven't looked at it, it's a tool for copying pilot-db
data to and from an SQL database.

It's still at <URL: http://www.mired.org:8080/downloads/palm/ >.

	<mike
-- 
Mike Meyer <mw...@mi...>		http://www.mired.org/consulting.html
Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information.

[pilot-db-list] =?iso-8859-1?Q?Icon?=

[=?iso-8859-1?Q?<mar...@la...>]

we need new icons for device on PalmOS 5.=0D=0Athe first 64x44=0D=0Athe s=
econd 30x18=0D=0AIt's for the launcher, if you can use the model of the=0D=
=0Acurrents icons, it will be better.=0A=0AAcc=E9dez au courrier =E9lectr=
onique de La Poste : www.laposte.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; =
t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

[pilot-db-list] =?iso-8859-1?Q?Re:_[pilot-db-list]_VFS_calculated_field_issue?=

[=?iso-8859-1?Q?<mar...@la...>]

I'm not sure that it's a good idea to enclose the VFS support=0D=0Ain the=
 main application it will increase a lot the size of=0D=0APilot-DB and i =
think that Pilot-DB begins to become too big (i=0D=0Ahave only 2Mb on my =
Palm). But i think that the VFS support=0D=0Amust be improved, for that w=
e must modify a little the main=0D=0Aapplication, and change the whole so=
urce code of the plugin.=0D=0A=0D=0A=0D=0A---------- Debut du message ini=
tial -----------=0D=0A=0D=0ADe     : pil...@li...urceforg=
e.net=0D=0AA      : Craig Bowers <cr...@bo...>=0D=0ACopies : Pilot-d=
b-list <Pil...@li...>=0D=0ADate   : Wed, 19 Mar 20=
03 09:19:28 -0500 (EST)=0D=0AObjet  : Re: [pilot-db-list] VFS calculated =
field issue=0D=0A=0D=0A=0D=0AI believe that calculated field support is n=
ot in the db3 vfs=0D=0Aplugin in =0D=0Aeither db-1.1 or db-1.0.x  I know =
that the db3vfs plugin is=0D=0Agetting close =0D=0Ato 32k in size and add=
ing script support will make it=0D=0Anecessary to build =0D=0Ait as a mul=
ti-segment library (I'm not actually sure if this=0D=0Ais possible).=0D=0A=
=0D=0AFor the next release of db-1.1, I plan on adding vfs support=0D=0Ad=
irectly to =0D=0Adb itself (so you won't need a seperate plugin).  This w=
ill=0D=0Agive you =0D=0Aaccess to calculated fields no matter where the d=
atabase is=0D=0Astored.=0D=0A=0D=0A	-Scott=0D=0A=0D=0A=0D=0A=0D=0A> Furth=
er detail on VFS calculated field issue with 1.1b2 (and=0D=0Athe 1.1b2=0D=
=0A> plugins in separate download):=0D=0A> Moving the db to SD causes cal=
culated fields to display=0D=0Aunsupported field=0D=0A> type.=0D=0A> Edit=
ing attempts to the record can produce this Fatal alert:=0D=0A> =0D=0A> .=
/ ../ ../src/drivers/db3.c,=0D=0A> Line:940,=0D=0A> DB-PackedRecordSize:=0D=
=0A> unsupported field type=0D=0A> =0D=0A> =0D=0A> =0D=0A> --------------=
-----------------------------------------=0D=0A> This SF.net email is spo=
nsored by: Does your code think in ink? =0D=0A> You could win a Tablet PC=
. Get a free Tablet PC hat just for=0D=0Aplaying. =0D=0A> What are you wa=
iting for?=0D=0A> http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043=
en=0D=0A> _______________________________________________=0D=0A> Pilot-db=
-list mailing list=0D=0A> Pil...@li...=0D=0A> http=
s://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A> =0D=0A=0D=0A=
-- =0D=0A=0D=0A=0D=0A=0D=0A----------------------------------------------=
---------=0D=0AThis SF.net email is sponsored by: Does your code think in=
 ink? =0D=0AYou could win a Tablet PC. Get a free Tablet PC hat just for=0D=
=0Aplaying. =0D=0AWhat are you waiting for?=0D=0Ahttp://ads.sourceforge.n=
et/cgi-bin/redirect.pl?micr5043en=0D=0A__________________________________=
_____________=0D=0APilot-db-list mailing list=0D=0AP...@li...=
urceforge.net=0D=0Ahttps://lists.sourceforge.net/lists/listinfo/pilot-db-=
list=0D=0A=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.la=
poste.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,3=
4=80/mn)"=0A=0A

Re: [pilot-db-list] Brialliant DB!

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

On Wed, 19 Mar 2003, Brian Clark wrote:

>  Use it all the time for personal and home stuff. Fast, easy to use and not
>  tied to a PC every time you need to make a database change (very, useful!)
> 
>  If I could use LINKED fields in calculations my world would be complete -
>  but hey it is free and I'm grateful!
> 

	Well you can't get do everything with Linked fields yet, but if 
they are integers in the source database, you can use the (int) operator 
to effectively change them from the strings back into integers.  This lets 
you do some math with linked fields.  Perhaps I will try to add some more 
casting operators for the next version.

	-Scott

Re: [pilot-db-list] Re: [pilot-db-list] File format questions...

[Norman W. <nd...@nw...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

/ "mar...@la..." <mar...@la...> was heard to say:
| What tools do you want to use? (Java, libxml2, xercesc,
| expat...) Perhaps you saw i wanted to begin some thing to save
| the database in xml format. If you want my first ideas, i can
| send you my DTD or other things.

I'm building conduits[1] for PilotManager[2]. They're Perl based,
built on top of pilot-link[3]. There are some folks working on the
Java bindings for pilot-link and I might someday build a new sync
framework that's Java based, but for the moment I'm content with
PilotManager.

| I have a question for you,
| how can we generate easily our documentation from the DocBook
| xml? The most important tools for DocBook are available in

The DocBook Open Repository project at SF.net
(http://sf.net//projects/docbook) maintains a set of XSL stylesheets
that work with DocBook XML. All serious future development is in the
XSL toolchain, so it's XML based not SGML based.

| SGML format. Is it possible to generate the documentation from
| our website? I would like to put the xml file on the website,
| and a tool will generate the html format at the first request
| to read the documentation. Is it possible?

I'm sure it would be possible, but it's probably easier to just build
the HTML offline and publish them simultaneously.

                                        Be seeing you,
                                          norm

[1] http://www.sun.com/software/xml/developers/palm/
[2] http://www.moshpit.org/pilotmgr/
[3] http://www.pilot-link.org/

- -- 
Norman Walsh <nd...@nw...> | 'Heartless Cynics,' the young men
http://nwalsh.com/            | shout, / Blind to the world of Fact
                              | without; / 'Silly Dreamers,' the old
                              | men grin / Deaf to the world of Purpose
                              | within.--W. H. Auden
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.7 <http://mailcrypt.sourceforge.net/>

iD8DBQE+eH3AOyltUcwYWjsRApxCAJ9jOReCdGHtl8xKWp6qdEMB4gPDtACfYSHp
PuUoC0B4mE3tKh/8WI5OneQ=
=h3EN
-----END PGP SIGNATURE-----

Re: [pilot-db-list] Filters and Booleans

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

Thanks for this report, I think this should be easy to fix.
	
	-Scott

	
> I have one database that uses a Boolean field to select members of a
> record subset for display via a filter.
> 
> If you set some Boolean values to false from the list view and reselect
> the filter (filtering for values of "1" on that field) those records
> remain in the set (despite their "0" value).
> 
> Yet if you set the Boolean field(s) to false from the record edit view
> instead, then when returning to the list view, the record(s) are removed
> from the set via the filter, as expected.
> 
> So, in short it seems that Filters cannot see changes in values made in
> the list mode.
> 
> 

Re: [pilot-db-list] VFS calculated field issue

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

I believe that calculated field support is not in the db3 vfs plugin in 
either db-1.1 or db-1.0.x  I know that the db3vfs plugin is getting close 
to 32k in size and adding script support will make it necessary to build 
it as a multi-segment library (I'm not actually sure if this is possible).

For the next release of db-1.1, I plan on adding vfs support directly to 
db itself (so you won't need a seperate plugin).  This will give you 
access to calculated fields no matter where the database is stored.

	-Scott



> Further detail on VFS calculated field issue with 1.1b2 (and the 1.1b2
> plugins in separate download):
> Moving the db to SD causes calculated fields to display unsupported field
> type.
> Editing attempts to the record can produce this Fatal alert:
> 
> ./ ../ ../src/drivers/db3.c,
> Line:940,
> DB-PackedRecordSize:
> unsupported field type
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Does your code think in ink? 
> You could win a Tablet PC. Get a free Tablet PC hat just for playing. 
> What are you waiting for?
> http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

-- 

[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Brialliant_DB!?=

[=?iso-8859-1?Q?<mar...@la...>]

Thank you.=0D=0A=0D=0A---------- Debut du message initial -----------=0D=0A=
=0D=0ADe     : pil...@li...=0D=0AA      : pi=
lot...@li...=0D=0ACopies : =0D=0ADate   : Wed, 19 Ma=
r 2003 10:07:59 +0000=0D=0AObjet  : [pilot-db-list] Brialliant DB!=0D=0A=0D=
=0A Use it all the time for personal and home stuff. Fast, easy=0D=0Ato u=
se and not=0D=0A tied to a PC every time you need to make a database chan=
ge=0D=0A(very, useful!)=0D=0A=0D=0A If I could use LINKED fields in calcu=
lations my world would=0D=0Abe complete -=0D=0A but hey it is free and I'=
m grateful!=0D=0A=0D=0A=0D=0ABrian Clark=0D=0A=0D=0Ab...@vx...=0D=
=0AThis message  does not necessarily reflect the views,=0D=0Aopinions, p=
olicies or=0D=0Aprocedures of Basildon District Council or it's partners =
and=0D=0Adoes not give=0D=0Arise to any contract, undertaking or agreemen=
t. E-mail is not=0D=0Aa secure form=0D=0Aof communication.=0D=0A=0D=0AEve=
ry effort has been made to ensure that this message has=0D=0Abeen correct=
ly=0D=0Aaddressed. It and any associated file(s) may contain privileged o=
r=0D=0Aconfidential information or details intended only for the=0D=0Asen=
der and the=0D=0Aintended recipient.  If this message is received by anyo=
ne=0D=0Aother than the=0D=0Aintended recipient please delete the message =
and any=0D=0Aassociated file(s) and=0D=0Adestroy any printed copy. Please=
 notify the sender by a return=0D=0Ae-mail or=0D=0Atelephone and make the=
m aware that the message has been=0D=0Areceived by someone=0D=0Aother tha=
n the intended recipient.=0D=0A=0D=0AIf the subject line of this email be=
gins PER: then the email=0D=0Ais a personal=0D=0Aone and is the personal =
responsibility of the sender and not=0D=0ABasildon=0D=0ADistrict Council =
or its partners.=0D=0A=0D=0A=0D=0A---------------------------------------=
----------------=0D=0AThis SF.net email is sponsored by: Does your code t=
hink in ink? =0D=0AYou could win a Tablet PC. Get a free Tablet PC hat ju=
st for=0D=0Aplaying. =0D=0AWhat are you waiting for?=0D=0Ahttp://ads.sour=
ceforge.net/cgi-bin/redirect.pl?micr5043en=0D=0A_________________________=
______________________=0D=0APilot-db-list mailing list=0D=0APilot-db-list=
@lists.sourceforge.net=0D=0Ahttps://lists.sourceforge.net/lists/listinfo/=
pilot-db-list=0D=0A=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste=
 : www.laposte.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 1=
3 50 (0,34=80/mn)"=0A=0A

[pilot-db-list] Brialliant DB!

[Brian C. <bri...@ba...>]

 Use it all the time for personal and home stuff=2E Fast, easy to use and not
 tied to a PC every time you need to make a database change (very, useful!)

 If I could use LINKED fields in calculations my world would be complete -
 but hey it is free and I'm grateful!


Brian Clark

brian95@vxtras=2Ecom
This message  does not necessarily reflect the views, opinions, policies or
procedures of Basildon District Council or it's partners and does not give
rise to any contract, undertaking or agreement=2E E-mail is not a secure form
of communication=2E

Every effort has been made to ensure that this message has been correctly
addressed=2E It and any associated file(s) may contain privileged or
confidential information or details intended only for the sender and the
intended recipient=2E  If this message is received by anyone other than the
intended recipient please delete the message and any associated file(s) and
destroy any printed copy=2E Please notify the sender by a return e-mail or
telephone and make them aware that the message has been received by someone
other than the intended recipient=2E

If the subject line of this email begins PER: then the email is a personal
one and is the personal responsibility of the sender and not Basildon
District Council or its partners=2E