Hi Thomas,
The database is one that has been around since late August 2010 - I
think that was about the time that h2-1.2.139 came out. I've done a
bit of research. I made a copy of AcctPriv.odb, changed the .odb
to .zip so that I could unpack the files and found the following -
>From forms.obj21.context.xml -
<form:form form:name="TransEntry"
form:command="PRIVACCTS.PUBLIC.TransHeader" form:allow-deletes="false"
form:apply-filter="true"
<form:form form:name="SubFormTransDetails"
form:command="PRIVACCTS.PUBLIC.TransDetails" form:apply-filter="true"
form:command-
>From PrivAccts.h2.db - (viewed with Notepad) -
ALTER TABLE PUBLIC."BankStatements" ADD CONSTRAINT PUBLIC.CONSTRAINT_1
PRIMARY KEY("BankStatID") INDEX PUBLIC.PRIMARY_KEY_1- !
In each of these examples the Table names are in upper and lower case,
so it seems that the way they have been stored is probably not the
problem.
I mentioned earlier that I have switched to LibreOffice 3.4.3. As a
further test I ran the system on my old PC using Windows XP,
OpenOffice 3.2 and H2 1.3.162. The system still could not load any of
the tables. So I don't thing LibreOffice is the problem either.
Has the format of the .odb files changed at all between H2 1.2.139 and
H2 1.3.162?
Alternatively is there anything else I could try?
The system works quite happily under H2 1.2.139, but that is not
really a permanent solution.
Thanks for your help
Noel
On Jan 19, 11:19 pm, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> Did you create a new database? I don't think it will work if the database
> already exists (as the table name would have been stored in all uppercase
> already).
>
> Regards,
> Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
