Re: [SQL] curly braces to group outer joins in queries from

[Palle Girgensohn]

Only, I set up postgreql to connect using JDBC... :(

So, the bug is that OO expects an ODBC connection, and I use JDBC... Seems 
logical. I'll go ask the ODBC guys. Thanks for you help,

/Palle

--On tisdag, november 11, 2003 11.28.57 -0500 Tom Lane <[EMAIL PROTECTED]> 
wrote:

Palle Girgensohn <[EMAIL PROTECTED]> writes:
Here's their code snippet (from
oo_1.1_src/dbaccess/source/ui/querydesign/QueryDesignView.cxx):

if(aJoin.getLength())
{
        ::rtl::OUString aStr = ::rtl::OUString::createFromAscii("{ OJ ");
        aStr += aJoin;
        aStr += ::rtl::OUString::createFromAscii(" },");
        aTableListStr += aStr;
}
Now that I look at it, I bet that they are expecting the ODBC driver to
translate "{ OJ ... }" into the appropriate syntax for the database
(either SQL standard or not, depending on the DB :-().
There are a number of ODBC brace-constructs that our driver knows how to
translate, but I don't think that's one of them.  You should bug the
ODBC guys about it.
			regards, tom lane




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html