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 ;)
--francois
On 10/11/05, Daniel John Debrunner <[EMAIL PROTECTED]> 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.
