[libreoffice-users] Re: LibréOffice Base Forms, PostgreSQL (JDBC) and Table Joins

Le 25/02/2014 10:08, Alex Thurgood a écrit :

Hunting this down a bit more :

https://issues.apache.org/ooo/show_bug.cgi?id=114280#c6

so it would appear that there should be an extra option in JDBC
connection settings "Advanced Settings" dialog that allows you to switch
on "replace named parameters with '?'

At least, that was the case for OOo 3.3.0.

If it is no longer there, then that option was either deleted from the
dialog for some reason, or the code that reads the available driver
options fails (for some other reason) or else ignores that setting
possibility and so is not present in the UI dialog.

See also :

https://issues.apache.org/ooo/show_bug.cgi?id=113631

If the UI dialog no longer allows this to be set, it might be a good
idea to file a bug request and ask that it be reinstated, or else if the
UI does allow it to be set, but that setting it doesn't work, then this
would be another bug.

Alternatively, it is possible to pass connection parameters directly in
the connection string when setting up the database connection, e.g. by
adding the connection parameter statement in the URL of the db
connection wizard :

?


Also check whether, as per Frank Schönheit's (former OOo Base dev)
comment here :

https://issues.apache.org/ooo/show_bug.cgi?id=113631#c19

the two ID fields have different INT types, which Frank believed to be
responsible for triggering the linked ID display problem as reported by
Steve Shelton :

https://issues.apache.org/ooo/show_bug.cgi?id=113631#c17

Seeing as Frank's last report was made just before Oracle donated the
code to the ASF and just around the time the LibreOffice was created.
In comment 19, Frank reports that he is going to open a separate bug
report for the failed display of JOIN linked data in a subform, but he
may/may not have got around to that.




Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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