Menu

Error with export from BookCAT

Help
2015-01-16
2015-01-20
  • Börje Carlsson

    Börje Carlsson - 2015-01-16

    Hi,

    When exporting without filter the export is OK.
    But with a filter on "Author" I get following error report:

    Database Read Error

    Message:
    java.lang.IllegalArgumentException: Given index Name: (Person) SortBy
    Number: 5
    Is Primary Key: false
    Is Foreign Key: false
    Data number: 5
    Page number: 2265
    Is Backing Primary Key: false
    Is Unique: false
    Ignore Nulls: false
    Columns: [ColumnDescriptor Name: (Person) SortBy
    Type: 0xa (TEXT)
    Number: 3
    Length: 304
    Variable length: true
    Compressed Unicode: false
    Text Sort order: 1035(0)

    flags: 1]
    Initialized: false
    Cache: (uninitialized)

    is not usable for indexed lookups because it is read-only

    Thanks for any help.

    Börje

     
    • Tom van Breukelen

      The error message comes from a 3rd party library used by FNProg2PDA to access your database. Most likely your database has the very old MS-Access '97 format. That format is not so well supported by that library, especially when it try to read the database tables indexes. It could be that later versions of that library supports that format a bit better. Best bet however is to convert the database to a later format (like MS Accesss 2000, 2002, 2003, 2007 or 2010).

      Best regards,

      Tom

       
      • Börje Carlsson

        Börje Carlsson - 2015-01-18

        Thanks for the answer.
        I see, but how do I do that?

        I thought the library handler came along with the BookCAT program. My version of BookCAT is v 10.13 dated 2012-02-08.

        Best regards
        Börje

         
      • Börje Carlsson

        Börje Carlsson - 2015-01-19

        Hello,

        It seems that it works OK with the Sample database that came with BookCAT.
        How do I convert to a later database format?

        Thanks,

        Börje

         
        • Tom van Breukelen

          As far as I know you can copy all records in BookCAT from your database into a new one. That should create a new database with the correct format. If that doesn't work the database conversion can be done with MS-Access. I should still have a backup copy of MS-Office Pro 2002 or 2003 lying around somewhere.

          Cheers,

          Tom

           
          • Börje Carlsson

            Börje Carlsson - 2015-01-20

            YES,
            I copied all records to a new database and now it works.
            I used CAT-programs almost since the beginning so some databases can be quite old.
            Thanks for your help and your nice application, I still depend on my Palm TX.

            Thanks
            Börje

             

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.