Hi Santiago,
> I'm a little confused about [OPTIONAL]s in the API. I was using the ODBC
> driver with a PostgreSQL database. The call to createDataDescriptor
> doesn't fail, but seems to return nothing.
In general, if an OPTIONAL interface is present, it should do what is
defined. If it cannot fu
El jue, 18-08-2005 a las 12:11, Frank Schönheit - Sun Microsystems
Germany escribió:
> Hi Santiago,
>
> sorry for the delay in answering, this shouldn't have happened,
> especially since you're new to this list :-\. So, a late "Welcome" from
> my side :)
No problem. Sometimes I don't have the tim
One latst piece of information before I let this go for the moment.
Some of the examples of when you must use Column names, and when you
MUST have Escape Processing OFF is dependent not only on theHSQL
statement but on WHICH data type is passed in.
The date to string functions are this way. F
Hallo Frank
No issue for now then. Perhaps it is more fitting in user faq
document.anyway.
Andrew
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew.
Change the select statement to
SELECT CASE DATA WHEN '' THEN 'X' WHEN '' THEN 'Y' WHEN ''
THEN 'Z' ELSE '
Hi Andrew.
> Change the select statement to
>
> SELECT CASE DATA WHEN '' THEN 'X' WHEN '' THEN 'Y' WHEN ''
> THEN 'Z' ELSE 'NOTFOUND' END AS "DATA" FROM TESTCASE
>
>
> It still requires that EscapeProcessing = false.
The HSQLDB engine is capable of more things that OOo's cross-DB
