[pilot-db-list] lists limited to 32 chars? also how to diagnose fatal exceptions?

[Michael G. <ma...@th...>]

There seem to be a limit of 32 items for list fields.  Is this hard-coded
anywhere?  Can it be changed?

I tried working around this by splitting my big list into two smaller
lists.  This actually works pretty well.  For the view, I created a
calculated field which displays the value of whichever menu has
an item selected.  Here's the script:

    (? (seq %1 'N/A') %2 %1)

Or a slightly cleaner version which leaves the field blank when nothing
in either menu is selected:

    (? (seq %1 'N/A')
        (? (seq %2 'N/A')
            ''
            %2
        )
        %1
    )

This works nicely.

Unfortunately, I'm having trouble changing my database to incorporate
the changes.  I'm getting Fatal Exceptions whenever I add or modify
fields (or when I duplicate the database).  These happen both with 1.0.3
and the Oct 14 snapshot.

The crash dialog doesn't provide any info.  What can I do to help
diagnose these crashes?

I do know that one of the crashes I was having is from the palm-db-tools
converter - It doesn't respect the 32 list item limit: instead it just
adds all the list items to the pdb, and corrupts the db in the process.

Michael

P.S.  Pilot-DB is great!  Big thanks to the developers!


--
Michael Graham
ma...@th...