Le 24/02/2014 15:24, Jim Seymour a écrit :
What are the settings in the "Advanced Options" of your db connection
for that ODB file ?
"Edit -> Advanced Settings -> Database -> Special Settings", perhaps?
Options checked are:
Ignore the privileges from the database driver
Use catalog name in SELECT statements
Use schema name in SELECT statements
Create index with ASC or DESC statement
Form data input checks for required fields
Use ODBC conformant data/time literals
Comparison of Boolean values: Default
OK, so probably not where the problem lies.
Not sure about the "Form data input checks for required fields" option
though. If the primary key of your subform requires input/updating and
this is not bound to the form, perhaps that might explain where your
error is coming from.
Which driver version of JDBC are you using ?
Which version of postgres ?
PostgreSQL v8.4.19 w/postgresql-jdbc4-9.1.jar at work
PostgreSQL v8.4.19 w/postgresql-jdbc3-8.4.jar at home
There was an issue with writing to postgresql servers using versions
prior to 8.4, so that shouldn't be the problem here.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- Re: [libreoffice-users] LibréOffice Base Forms, PostgreSQL (JDBC) and Table Joins (continued)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy