Re: Using Oracle-OLEDB-provider to query meta-data (restrictions do not work)

I am using the openschema-method, of course. The problem is indeed to filter it appropriately to get only the tables, constraints, indexes from a specific user.
filter-criteria for e.g. tables are :
CATALOG,SCHEMA, TABLE_NAME, TABLE_TYPE so when I try various filter-criteria like

null, <username>, null, "TABLE" or even

null, null, null, TABLE

it gives back a NOT supported !

only when doing the unrestricted call I get back data:

too much, messy data

On SQLServer my code produces excellent results.

Arjan Received on Thu Nov 18 1999 - 04:25:20 CST