[ 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.
|
