pilot-db-list

[pilot-db-list] unable to open database

[The W. <rsj...@sb...>]

My palm crashed  (IIIxe  Palm OS 3.5.0) and post backup cannot open my 
databases  Reloaded DB 0.3.3 twice and tried new version with no success 
 What am i doing wrong?  Many thanks

[pilot-db-list] Excel macro

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

A new version of my excel macros is available at this address:

http://trk.free.fr/xldbtool/

Thomas

[pilot-db-list] Running the system and keeping DBs on MMC card

[Edwin <edw...@pd...>]

I know it's been mentioned here before but I can't seem to find the infor
from the site of previous mails received.
Plus the last time I tried what was mentioned I did not get it to work.

My problem is that after installing the latest version of Pilot-DB, i.e.
version 1.0.2 and the set of plugins, it's taken up so much of my Palm's
main memory that I have almost none left to do anything else. I have
installed a 64MB MMC card in my M505 and was wondering if there was a way to
run the entire database system, i.e. *.prc and the various databases on the
MMC card itself instead of the main memory.

Thanks in advance.

Edwin

P.S. Anyone want to email directly, can do so at edw...@pd...

Re: [pilot-db-list] Delete list from DB-pilot

[Marc C. <mar...@la...>]

I'm sorry but i will not add twice the same function. To rename a 
database you must select the database and that means to add a new 
dialogbox if i implement this in the menu.
I wrote a documentation where the icon menu is explained!

Kelly Shane Harrelson wrote:
> It might be a nice idea to add these commands to 
> the menu as well...
> -Shane
> 
> ----- Original Message ----- 
> From: "Walter Koch" <ko...@u3...>
> To: <pil...@li...>
> Sent: Saturday, August 03, 2002 5:42 AM
> Subject: Re: [pilot-db-list] Delete list from DB-pilot
> 
> 
> 
>>Moin,
>>
>>Du schriebst am / on Wed, 31 Jul 2002 12:08:59 -0400 you wrote:
>>
>>
>>>1) Is it possible to delete a database from the list ?
>>>2) Is it possible to rename a database ?
>>
>>Both can be done by taping the icon right of the database name. 
>>
>>Gruss,
>>  Walter
>>
>>-- 
>>  Hochdahl am Neandertal
>>
>>
>>-------------------------------------------------------
>>This sf.net email is sponsored by:ThinkGeek
>>Welcome to geek heaven.
>>http://thinkgeek.com/sf
>>_______________________________________________
>>Pilot-db-list mailing list
>>Pil...@li...
>>https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>>
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

Re: [pilot-db-list] Delete list from DB-pilot

[Kelly S. H. <sh...@mo...>]

It might be a nice idea to add these commands to 
the menu as well...
-Shane

----- Original Message ----- 
From: "Walter Koch" <ko...@u3...>
To: <pil...@li...>
Sent: Saturday, August 03, 2002 5:42 AM
Subject: Re: [pilot-db-list] Delete list from DB-pilot


> Moin,
> 
> Du schriebst am / on Wed, 31 Jul 2002 12:08:59 -0400 you wrote:
> 
> > 1) Is it possible to delete a database from the list ?
> > 2) Is it possible to rename a database ?
> 
> Both can be done by taping the icon right of the database name. 
> 
> Gruss,
>   Walter
> 
> -- 
>   Hochdahl am Neandertal
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

Re: [pilot-db-list] Delete list from DB-pilot

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

Moin,

Du schriebst am / on Wed, 31 Jul 2002 12:08:59 -0400 you wrote:

> 1) Is it possible to delete a database from the list ?
> 2) Is it possible to rename a database ?

Both can be done by taping the icon right of the database name. 

Gruss,
  Walter

-- 
  Hochdahl am Neandertal

[pilot-db-list] unsubscibe

[JUSTIN B. <jjb...@ip...>]

[pilot-db-list] RE: palm-db-tools problem?

[Marc C. <mar...@la...>]

i'm sorry for the missing file!
Have you try a ./configure --help to see the options?
I added a --enable-gui option but i forget in what version.

I don't know enought JPilot-DB to tell if there is a trouble or not.
But if you build your database with pilot-db and in the main db format, 
you should not have trouble with palm-db-tools 0.3.3 (except that you 
must put "option read-only off" inside the info file)

 > Bonjour Marc,
 >
 > I'm using pilot-db 1.0.2 and managed to get it working on my palm m105.
 > Now I want to get a database from my palm to my Linux workstation and 
try to get it
 > into gnumeric or OpenOffice. So I downloaded the db-tools 0.3.4 
tar-ball but when I configure
 > it I run into the error:
 >
 > config.status: creating gui/q/Makefile
 > config.status: error: cannot find input file: gui/q/Makefile.in
 > [root@nl-l-mspringer2 palm-db-tools]#
 >
 > And when I check the gui/q directory the Makefile.in isn't there. 
When I check the tar-ball: it isn't
 > there also: it appears to be missing.
 >
 > So I tried the 0.3.3 version which I could configure and make. 
However, when I try the
 > pdb2csv utility to convert a file it gives with my database from 
pilot-db kilometeradministratie:
 >
 > bash-2.05$ pdb2csv  kilometeradministratie.pdb kilometeradmin.csv 
kilometeradmin.info
 > kilometeradministratie.pdb: unsupported field type
 > bash-2.05$
 >
 > Even when I try an original Palm-file (like AddressDB.pdb) it gives 
the same error-message.
 > I use by the way JPilot to sync my Palm with my Linux-workstation: 
might this be the problem?
 >
 > Merci beaucoup!
 >
 > Regards,
 >
 > Mark
 >
 > _________________________________
 >
 > Mark Springer
 > Unix Technical Support Specialist
 > Central Support Services
 >
 > Getronics Infrastructure Solutions BV
 > Marconibaan 5, 3439 MR  Nieuwegein
 > Postbus 439, 3430 AK  Nieuwegein
 > Tel.: +31 30 600 5432
 > Fax: +31 30 600 5507
 > mailto:mar...@ge...
 > http://www.getronics.com
 >
 > Support-aanvragen
 > Getronics Operation Centre
 > Tel: +31 (0)30 6005544
 >
 > The information transmitted is intended only for use by the addressee 
and may contain confidential and/or privileged material. Any review, 
re-transmission, dissemination or other use of it, or the taking of any 
action in reliance upon this information by persons and/or entities 
other than the intended recipient is prohibited. If you received this in 
error, please inform the sender and/or addressee immediately and delete 
the material.
 > Thank you.
 >
 >
 >

[pilot-db-list] JFile4/5

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

Is it possible to conver JFile4/5 databases to Pilot-DB
or just JFIle3?

There are a few non-game databases at
http://palmpilotspiele.de.vu/
that are of interest to me, and probably others
too, but they are in JFILE4/5 format.

Can anyone convert them?

Hans

[pilot-db-list] Sample Database

[Peter S. <ge...@ly...>]

Hello

I like the program very much.

So I create some databases for my personal life. To share this I build a
site under www.databank4p.tk .

May be they are helpful. But this site is still in German.

See you

Peter

BTW

Will be there a new version of the program?

[pilot-db-list] Delete list from DB-pilot

[Leblanc, N. (N.J.) <nle...@ja...>]

Hi,

I have been using Pilot-DB and think it's a brilliant tool. It is so
flexible, I can create any database I want. I have two questions :
1) Is it possible to delete a database from the list ?
2) Is it possible to rename a database ?

I hope you keep developping this database as it beats any other one I have
tried so far.

Thanks for your time
Nick

-----------
Regards,
                                       
Nicolas Leblanc
W/1/012 - CAE - Body Engineering - Jaguar Cars Ltd

Re: [pilot-db-list] Calculated fields

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

On Wed, 31 Jul 2002, Hynek Sladky wrote:

> Hello, I would like to ask you if it is possible to include scripts
> for calculated fields while creating on PC. I have two databases in
> Access and I need to export them often to Palm but I need to add
> calculated fields. But when I add them, the script is empty - so I
> must write it everytime I export it and convert it to PilotDB. Is
> there any possibility how to do it?
> 
> Thanks,
> Hynek Sladky
> 


	Yes, currently, I think you are right, it is not possible to add 
scripts on the pc side.  Perhaps in a future release, but currently only 
Marc has been developing the PC side tool, and I think he prefers to spend 
his time on the palm side of the application.  However, the new version of 
the scripting library is much more portable, and should not be too 
difficult to integrate into the PC side tool, so hopefully this can happen 
in the near future.

	-Scott

[pilot-db-list] Filters

[Hynek S. <sl...@ja...>]

How to do multiple filters, If I have more than one criteria? How to save the filter if I need convert new database content from
PC to Palm? How to remove the filter or edit it?
I am sorry for so much questions... but this database is nice for my purposes and I need to use it.
Hynek Sladky

[pilot-db-list] Calculated fields

[Hynek S. <sl...@ja...>]

Hello,
I would like to ask you if it is possible to include scripts for calculated fields while creating on PC. I have two databases in
Access and I need to export them often to Palm but I need to add calculated fields. But when I add them, the script is empty - so
I must write it everytime I export it and convert it to PilotDB. Is there any possibility how to do it?

Thanks,
Hynek Sladky

Re: [pilot-db-list] csv2pdb and lists

[Kelly S. H. <sh...@mo...>]

from looking at the code in db.cpp, it looks like 
the separator used for list members in the info 
file used by csv2pdb is hardcoded to be a "/", with no "escape"
machanism or other means for entries that need to contain
a "/", such as in the example i gave below.

i'll look at adding an escape to slashes to be
included (ie. "1\/2/1\/3/1\/4" -> 1/2, 1/3, and 1/4)
and post my modify source here.

-shane

----- Original Message ----- 
From: "Kelly Shane Harrelson" <sh...@mo...>
To: <pil...@li...>
Sent: Monday, July 29, 2002 3:47 PM
Subject: [pilot-db-list] csv2pdb and lists


> in the info file, how do i specify a list member that
> contains a "/" ?  for instance, in a size category,
> suppose i wanted 1/2, 1/3, and 1/4 to be options?
>  
> also, it would be a nice feature if you didn't specify any
> values for a list, it would create the list as all the unique
> values of that field from the CSV file.
>  
> thanks.
> -shane
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: Dice - The leading online job board
> for high-tech professionals. Search and apply for tech jobs today!
> http://seeker.dice.com/seeker.epl?rel_code=31
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

[pilot-db-list] another db.cpp bug and fix for list field

[Kelly S. H. <sh...@mo...>]

in file db.cpp
in function PalmLib::FlatFile::DB::make_record()
around line 703:
    // mob_ksh 29 Jul/2002 V- DB format uses 8 bits to store list id 
    // we still increment by sizeof(pi_int16_t) to avoid alignment issues
    // PalmLib::set_short(p, itemID);
    *p = itemID;
    p += sizeof(pi_int16_t);

[pilot-db-list] db.ccp bug and fix for list field

[Kelly S. H. <sh...@mo...>]

in file db.cpp
in function PalmLib::FlatFile::DB::make_record()
around line 700:
            if (itemID != -1 && fieldData.v_string == data.substr( pos,
std::string::npos)) {
                itemID = j;
            }
should be:
            // mob_ksh check should be == -1, cause we are checking the last
value...
            if (itemID == -1 && fieldData.v_string == data.substr( pos,
std::string::npos)) {
                itemID = j;
            }

[pilot-db-list] csv2pdb and lists

[Kelly S. H. <sh...@mo...>]

in the info file, how do i specify a list member that
contains a "/" ?  for instance, in a size category,
suppose i wanted 1/2, 1/3, and 1/4 to be options?
 
also, it would be a nice feature if you didn't specify any
values for a list, it would create the list as all the unique
values of that field from the CSV file.
 
thanks.
-shane

[pilot-db-list] Fw: csv2pdb and lists

[Kelly S. H. <sh...@mo...>]

in the info file, how do i specify a list member that
contains a "/" ?  for instance, in a size category,
suppose i wanted 1/2, 1/3, and 1/4 to be options?

also, it would be a nice feature if you didn't specify any
values for a list, it would create the list as all the unique
values of that field from the CSV file.

thanks.
-shane

[pilot-db-list] Problems with big databases?

[<kev...@ma...>]

Hi all.

I'm using the jtools-db to create a database file from xml.  When use 
it to generate only a few records all seems to work fine.  But when I 
use it to generate a very large database (5740 records, 780k) and load 
it into the palm, I end up with a complete lockup.  I ran this under 
the pc emulator too and it reported writing to memory location 0x4.

Do you think this is a problem with the jtools-db system, or with large 
data files, or what?

Thanks

Kevin Ruland

[pilot-db-list] bug ? in script engine ?

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

hi 2 all ;-)

i have problems with the script engine, the reference to a boolean 
field is somehow inconsistent

the column %6 is a boolean field, the column "Test" is the result of 
the following script
(+ %6 10 )
the column "Test" shows either "10" or "11" depending on the field in 
column 6 (true or false)

the following script always shows "0" in the column "SuDi", it 
doesn't matter whether the entry in column 6 is true or false
(? (eq %6 1 )1 0 )

the following screenshot shows the results of both formulas in the 
columns "SuDi" and "Test"

i tried to solve the problem with the formula
(? (seq %6 true) tr fa )
(in the correspodending csv file boolean is shown as true or false) 
but then the result is the entry: "[broken]" due to the mismatching 
types of string and boolean (int). this is not shown in the screen 
shot.


bug or my mistake ?

hope for answer

so long, ciao hermann

[pilot-db-list] Re: Pilot-db-list digest, Vol 1 #456 - 2 msgs

[herbela <he...@ad...>]

Thanks Tom--Oh, how I wish I posted the query days ago!!

----- Original Message -----
From: <pil...@li...>
To: <pil...@li...>
Sent: Friday, July 26, 2002 3:08 PM
Subject: Pilot-db-list digest, Vol 1 #456 - 2 msgs


: Send Pilot-db-list mailing list submissions to
: pil...@li...
:
: To subscribe or unsubscribe via the World Wide Web, visit
: https://lists.sourceforge.net/lists/listinfo/pilot-db-list
: or, via email, send a message with subject or body 'help' to
: pil...@li...
:
: You can reach the person managing the list at
: pil...@li...
:
: When replying, please edit your Subject line so it is more specific
: than "Re: Contents of Pilot-db-list digest..."
:
:
: Today's Topics:
:
:    1. Help CSV2PDB (herbela)
:    2. Re: Help CSV2PDB (Thomas Rohmer)
:
: --__--__--
:
: Message: 1
: From: "herbela" <he...@ad...>
: To: <pil...@li...>
: Date: Thu, 25 Jul 2002 15:19:00 -0400
: Subject: [pilot-db-list] Help CSV2PDB
:
: O.K. I was able to convert my csv database and load it and read it. (282 records).
: But I can't do any editing because there is a "Lock" icon at the bottom of the screen
: which indicates that it is "read only". It will not unlock on the main screen to "Open
: read\edit".
: What am I doing wrong? Is there an option or  a metadata signal that I missed?
:
: TIA
:
: Herb in Orlando
:
:
:
: --__--__--
:
: Message: 2
: Date: Fri, 26 Jul 2002 11:26:00 +0200
: From: Thomas Rohmer <tr...@wa...>
: Reply-To:  tr...@or...
: To: herbela <he...@ad...>
: CC:  pil...@li...
: Subject: Re: [pilot-db-list] Help CSV2PDB
:
: This is a known bug from an old version of pilot-db-tools.
: Get the latest version 0.3.4
:
: Thomas
:
: herbela wrote:
:
: >O.K. I was able to convert my csv database and load it and read it. (282 records).
: >But I can't do any editing because there is a "Lock" icon at the bottom of the screen
: >which indicates that it is "read only". It will not unlock on the main screen to
"Open
: >read\edit".
: >What am I doing wrong? Is there an option or  a metadata signal that I missed?
: >
: >TIA
: >
: >Herb in Orlando
: >
: >
: >
: >
: >
:
:
:
:
:
:
: --__--__--
:
: _______________________________________________
: Pilot-db-list mailing list
: Pil...@li...
: https://lists.sourceforge.net/lists/listinfo/pilot-db-list
:
:
: End of Pilot-db-list Digest
:

Re: [pilot-db-list] High Res feature in Pilot DB; Security?

[Marc C. <mar...@la...>]

Michael A. Koenecke wrote:
> Sorry to ask such an obvious question, but how exactly does one enable 
> high resolution support on pilot-db? I've got the feature checked, but 
> it's still in low resolution mode. I've tried this with Sony's 
> "high-res" assist both on and off for the program, but neither seems to 
> make any difference. I'm using it with a Sony Clie NR-70V.
> 

The high-Res is only beautifull menus and icons text. If Sony would like 
to make a really High-Res API, you could have more lines in the list 
views. But Sony gave us something to display only beautifull picture and 
nothing more. To do something like the previous version we must write 
code like a drunker, and i prefered to cut the bad code and look for 
another solution for the next version.

> Second query: any way to password-protect specific databases, or is that 
> an RFE?
> 

password-protect database -> RFE

> Cheers.
> -- 
> Mike Koenecke

Re: [pilot-db-list] Format internals - Field type codes

[Marc C. <mar...@la...>]

Thank you!

Lawrence Sproul wrote:
> I prepared this version of Format.txt to help me with my work. I hope
> you find it usefull as well.
> 
> --- Scott Wallace <swa...@my...> wrote:
> 
>>On Wed, 17 Jul 2002, R Vrajmohan wrote:
>>
>>
>>>Hi:
>>>
>>>The field type information in "format.txt" appears to be
>>
>>inconsistent.
>>
>>>In the CHUNK_FIELD_TYPES section, the codes are:
>>> 0 - String
>>>  1 - Boolean
>>>  2 - Integer
>>>  3 - Date
>>>  4 - Time
>>>  5 - Note
>>>There is nothing specified for List, Link, Float, etc.
>>
>>Thanks for pointing that out, I'll update it.
>>
>>
>>>Later on, in the description of the record structure, I am
>>
>>assuming that 
>>
>>>the field type codes are given parenthetically: 
>>
>>FIELD_TYPE_STRING (1), 
>>
>>>FIELD_TYPE_BOOLEAN (2), etc. These appear to be off-by-one.
>>>
>>
>>Yes, this is a bit confusing...
>>   
>>
>>
>>
>>>Also, how are null values treated in the record format?
>>>
>>
>>It depends on the data type, for numbers there is no null-value. 
>>Strings 
>>are dynamically sized fields, so only a null character is stored.  
>>Calculated fields will take up a few bytes.  I'm not sure about
>>linked and 
>>link fields though.  In general, some data structure will be saved
>>in the 
>>record, it just depends on how small that data structure can be...I
>>think 
>>they should all be in datasource.h if you want to take a closer
>>look.
>>
>>
>> -Scott
>>
>>
>>  
>>
>>
>>
>>-------------------------------------------------------
>>This sf.net email is sponsored by:ThinkGeek
>>Welcome to geek heaven.
>>http://thinkgeek.com/sf
>>_______________________________________________
>>Pilot-db-list mailing list
>>Pil...@li...
>>https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 
> 
> 
> 
> =====
> Check out my WebsiteTry  PayPal for making and reciving payments online from your bank account or credit card.
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Autos - Get free new car price quotes
> http://autos.yahoo.com
> 
> 
> ------------------------------------------------------------------------
> 
> Palm Database Header
> The general database format info was extracted from PalmOS Documentation. These item may be changed by Palm at any time.
>   Char *  DB_Name - a null-terminated string with maximum length of 31 characters. The database has placeholders for all 31 characters even if name is shorter.
>   Uint16  Attributes
>   Uint16  Version
>   Uint32  Creation date
>   Uint32  Modification date
>   Uint32  Last backup date
>   Uint32  Modification number
>   Uint32  AppInfoID
>   Uint32  SortInfoID
>   Char*4  Type
>   Char*4  Creator
>   Uint32  UniqueIDSeed
>   Uint32  RecordList (Where to find records) Not applicable to DB ?
>   Uint16  NumRecords (This is actually DB Specific but is duplicated in the AppInfoBlock )
> DB Database Format  
> The first database format that DB used was not designed to be extensible. Any additions to the format would break compatibility for previous versions. The new database format for DB is designed to be extensible so that any additional data added to the application information block will not break databases without that data.  
> The DB-specific format is used in the App Info Block. The format is split in 5 major sections. The 1st section is stored in the PDB Header and remaining secions are held elsewhere, The sections are: 
> 1- Database properties - This is the PDB header above plus the Uint16 Flags below..
> 2- Record structure - Number of fields, field names, field data types, 
> 3- Supplemental Field data - default values, scripts, link info, etc.
> 4- View/Sort/Find info - Views, find Options, view options.
> 5- Records - a series of records.
> Application Information Block  
> The application information block starts with a small header defining some values that all databases will have. The header is: 
>   UInt16 flags  
>   UInt16 num_fields 
> The flags are defined like :  
>  [F][E][D][C][B][A][9][8][7][6][5][4][3][2][1][0]  
>   |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |_ GlobalFind Enable  
>   |  |  |  |  |  |  |  |  |  |  |  |  |  |  |____ ??  
>   |  |  |__|__|__|__|__|__|__|__|__|__|__|_______ RFU  
>   |  |___________________________________________ Database protected 
>   |                                               by system password  
>   |______________________________________________ Database Read-only 
> RFU: Reseved for Future Use 
> The remainder of the data in the app info block is stored as "chunks". Each chunk consists of a simple header followed by the chunk data itself. All of the chunks sit contiguously in the app info block. The header of a chunk is: 
>   UInt16 chunk_type  
>   UInt16 data_size 
> The next section describes each chunk. For each chunk, the name and chunk_type value are given followed by a brief description of the chunk and its data. 
> CHUNK_FIELD_NAMES (0) 
> This chunk holds the name of each field in the database. The chunk data consists of a series of zero-terminated strings, one for each name. 
> CHUNK_FIELD_TYPES (1) 
> This chunk holds the type of each field in the database. The chunk data consists of a UInt16 for each field describing the field type: 
>   0 - String  	1 - Boolean  	2 - Integer  
>   3 - Date  	4 - Time  	5 - Note 
> CHUNK_FIELD_DATA (2) 
> This chunk contains data for some fields. Some field types can store some particular information. 
> List Field Type:  
>   UInt16 fieldNum  
>   UInt16 numItems  
>   UInt16 RFU  
>   Char * Items (each items is a null terminated string) 
> Link Field Type:  
>   Char * Name (of the database that holds the data) (Null terminated String) (Up to 31 Characters)
>   UInt16 fieldNum  
>   UInt32 recordID (of the ChooserDB record corresponding to the database.) 
>   UInt16 filedNum (of the record to display.) 
> Calculated Field Type:  
>   UInt16 fieldNum  
>   UInt8 bytecodeSize  
>   UInt8 version (0x10)  
>   UInt8 access  
>   UInt8 returnType  
>   UInt8 * bytecode (array of bytecodeSize bytes) 
> String Field Type:  
>   UInt16 fieldNum  
>   Char * defaultString (null terminated string.) 
> Integer Field Type:  
>   UInt16 fieldNum  
>   UInt32 defaultInteger  
>   UInt16 increment  
> Float Field Type:  
>   UInt16 fieldNum  
>   double defaultFloat 
> Date Field Type
>   Uint16 fieldNum
>   Uint8  UseCurrentDate&Time Flag
>   Uint32 Default Value
> Time Field Type
>   Uint16 FieldNum
>   Uint8  UseCurretnDate&TimeFlag
>   Uint16 DefaultTime
> 
> CHUNK_LISTVIEW_DEFINITION (64) 
> This chunk defines a set of columns to be displayed in the list view mode. Each column is defined by the width of the column in the display as well as the field from the database that will be displayed. The chunk data consists of a short header followed by an entry for each column: 
>   UInt16 flags  
>   UInt16 number_of_columns  
>   char name[32] 
>   UInt16 field_number  
>   UInt16 column_width 
> CHUNK_LISTVIEW_OPTIONS (65) 
> This chunk stores several of the options that the list view uses. There should be exactly one copy of this chunk in any DB database. Its format is as follows: 
>   UInt16 active_view  
>   UInt16 first_visible_record 
> CHUNK_LFIND_OPTIONS (128) 
> This chunk stores options for the local find dialog. There should be exactly one copy of this chunk in any DB database. Its format is as follows: 
>   UInt16 flags 
> Record Structure  
> Each record in a DB-format database consists of an offset table followed by the actual field data. The offset table exists so that it is extremely easy to find a field in the record. The offset table consists of one 16-bit unsigned integer (called UInt16 in the PalmOS SDK) for each field. Each entry in the array is the offset of the start of the corresponding field. 
> The format of each field type is: 
> FIELD_TYPE_STRING (1) 
> This field type is stored as a null-terminated string. 
> FIELD_TYPE_BOOLEAN (2) 
>   UInt8 value; 
> This field type stores simple flag values. For true, value will be  
> 1. For false, value will be 0. 
> FIELD_TYPE_INTEGER (3) 
>   Int32 value; 
> This field type is a 32-bit signed integer. 
> FIELD_TYPE_DATE (4) 
>   UInt16 year;  
>   UInt8  month;  
>   UInt8  day; 
> FIELD_TYPE_TIME (5) 
>   UInt8 hour;  
>   UInt8 minute; 
> FIELD_TYPE_NOTE (6) 
>   Char Tilte[11];  
>   UInt16 Note_Offset;  
>   Char Note[3kb]; 
> This field type is a null terminated string followed by the offset of the first char of the Note. The Note is a null terminated string placed at the end of the record. If the note is empty, the offset is null and there are nothing at the end of the record. 
> FIELD_TYPE_LIST (7) 
>   UInt8 itemID 
> FIELD_TYPE_LINK (8) 
>   UInt32 recordID  
>   Char * name (null terminated string.) 
> FIELD_TYPE_FLOAT (9) 
>   double value 
> FIELD_TYPE_CALCULATED (10) 
>   Unknown 
> Field_TYPE_LINKED (11)
>   Unknown
> 

Re: [pilot-db-list] DB 1.0.2

[Marc C. <mar...@la...>]

Redeemer Cleaner wrote:
> Question 1.
> 
> I just upgraded from DB 0.3.3 to 1.0.2  I cannot figure out how to change
> the column widths for any of my databases.  Seems like I've looked
> everywhere.  The Help info doesn't make sense: says to "Edit List Views"
> command; there is no such thing that I can find.
> 

you have the views and the views editor access in the left-top of the 
RecordList screen.


> Question 2.  I downloaded: British_English.PDB  and
> Clothes_Size_Conversion.PDB  and some other databases from
> http://pilot-db.sourceforge.net/databases/.  DB cannot read these, but it
> displays them in the list and backs them up to my backup.  When I chose
> Duplicate, I got Fatal Exception error and my Palm had to be reset.  I have
> the DB2 plugin installed.  Maybe I need to try one of the other DB's
> plugins? 
> 

Have you used the uninstall.prc file before to load the new db.prc???????

> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>