I have illustrated the problem through an example in the attached image. Please let me know if this is clear
Hi, I have tried my best to explain the bug I face. I have column A in a table which is bound to column B in another table. My use case is to fetch the lookup display values from parent table using the bound value. To achieve the above, I fetch the value of a cell using the following method. Object value = row.get(column.getName()); And then search for this value in bound column and get the display value. But if the value is an instance of ComplexValueForeignKey, I fetch the multi values and then...
Hi, I faced the following exception while getting the table names in a database for a particular file. java.lang.IllegalStateException: Row is deleted: 3523:240 (Db=.........;Table=MSysObjects) at com.healthmarketscience.jackcess.impl.TableImpl.requireNonDeletedRow(TableImpl.java:3061) at com.healthmarketscience.jackcess.impl.TableImpl.getRow(TableImpl.java:667) at com.healthmarketscience.jackcess.impl.CursorImpl.getCurrentRow(CursorImpl.java:699) at com.healthmarketscience.jackcess.impl.CursorImpl$BaseIterator.next(CursorImpl.java:822)...
I would like to know if it's possible to read an Access app available in Microsoft...
I get a non-zero value from table.getRowCount() eventhough it has no data and at...
Database db = new DatabaseBuilder().setReadOnly(true).setCodecProvider(new CryptCodecProvider("test")).open(file);...
Hi, I tried to open a password protected Access 2007 database with jackcess-encrypt-2.1.1.jar...
Thanks for the answer.
Unable to parse the following statement containing latin small letter I, SELECT [CategorÃas].[CategorÃa]...
For few tables, the order of iteration of the columns is not the same as in the Access...
Is it possible to open the database by passing InputStream instead of File objec...
That didn't fix the issue. Any other solution? I tried with 2.1.4 as well as 2.1...
I get the following IOException message while opening the database, file format [V1997...
Thank you. That seems to be the perfection solution for me. But in the case of multivalue...
Table1 has Columns A,B,C Table2 has Columns X,Y,Z Table2.X looks up at Table1 for...
How to find if a column is a lookup and also the source column from another table...