db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francois Orsini <francois.ors...@gmail.com>
Subject Re: [Fwd: Re: How to run the Apache DB Torque tutorial with Derby]
Date Thu, 13 Oct 2005 00:28:01 GMT
Well in the case of ResultSetMetaData.isSearchable, ODBC semantics are
pretty clear.

Looking at the ODBC SQL_DESC_SEARCHABLE attribute and confirmed by Lance:
SQL_PRED_SEARCHABLE states, "if the column can be used in a WHERE clause
with any comparison operator." It definitely applies to the WHERE clause and
was added specifically so interactive applications could choose which
comparison operators (if any) could be used in a drop down box for query
builder type sequences.

So yes ResultSetMetaData.isSearchable applies to the Table ;)


On 10/11/05, Daniel John Debrunner <djd@debrunners.com> wrote:
> The ODBC argument is pretty powerful that the ResultSetMetaData
> describes the ResultSet, not the underlying table.
> But then we have ResultSetMetaData.isSearchable, that definitely is
> describing the underlying table and not the result set. Maybe it's the
> exception that proves the rule :-)
> Dan.

View raw message