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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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
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
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
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
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