[pilot-db-list] Re: bug in DB??

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

[ reply directed to list so others can benefit from answer ]

On Monday 09 April 2001 12:21, you wrote:

> I just installed DB 3.1 and may have run across a bug.  The bug may
> be in the db tools (cvs2pdb).  Here is what happened.
>
> I created a database for a bus schedule.  The info file is
>
> title "96 Inbound, Daily"
> field "Medford Square" string 100
> field "Powder House" string 100
> field "Harvard Square" string 100
>
> [ data file edited out ]
>
> I ran csv2pdb with no problems after building it on my RH 6.2 box.
> The resulting pdb file was usable on my pilot (III running OS 3.5)
> after a hotsync using jpilot.  I then edited the database format and
> changed string to time for the Medford Square field.  This caused all
> Medford Square entries to have the same time (bug?).  Then I changed
> the field back to string, and the entire database seemed to have lost
> its records (bug?).  I then re-installed the database...

The limitation is in the code in DB which rebuilds the database when field 
types change. I was lazy and didn't write the code to parse a string and 
convert it to a time. I could probably adapt the code from the palm-db-tools 
but I don't know when it would get done.