[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_lists_limited_to_32_chars=3F__also_how_to_diagnose_fatal_exceptions=3F?=

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

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

No, it's impossible (if i remember well the code). You should
use the link field to extend the choice.

> 
> 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?

A little more work for us :| We will see!

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

Yes, but a new version will come soon.

> 
> Michael
> 
> P.S.  Pilot-DB is great!  Big thanks to the developers!
> 
> 
> --
> Michael Graham
> ma...@th...


Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"