Hy
after some tests I hav a problem.
After writing data on a table I cannot execute queries.
The table name is bolrighe.
This query works "SELECT * from bolrighe where copia = 1"
This query works "SELECT * from bolrighe where copia = 1 and COMPOCODKEY<>''"
This query doesnt work "SELECT * from bolrighe where copia = 1 and COMPOCODKEY<>'' and numbolla = 27052"
I don't know why.
Maybe I can send to you the MDB files ? is Yes how cna I send to you the MDB ?
Thks
Hy
|
What's your error message?
You can send support @ hxtt.com your sample.
|
Message error is in Italian.
I translate for you.
"Impossible to open database ''. It's possible that database is not recognized for application or file is damaged".
Of cours this in ACCESS.
I send to you the zip file.
Thks
|
After run once
reindex all on bolrighe;
your issue should disappear.
So that should be an index issue.
What did program insert those records? Whether haven't you used lockType=ACCESS connection property?
|
Hy
this is the connection URL we use
jdbc:access:///c:\\dati\\pictures.mdb?delayedClose=0;lockType=ACCESS .
We use IsCobol that is an Cobol that support Java. This means that Cobol Source Code can use Java libraries and then when compiled it creates a Java file and then a JAVACLASS.
IN any case I send to you the LOG FILE when I run the program as you can see how we add data to the BOLRIGHE table.
Problem happens when I write a lot of data...and not always!
Hy
|
2019-09-18 fix a seldom index format compatible bug for level information of root node when it downgrade from index node to leaf node. It does not influence data, but MS Access will think it's incorrect.
Please redownload it.
|