What controls the Table list
Hi
In Query Wizard and Query Designer I get repeating of table names. I am
connecting to ORACLE and I do indeed have 3 schemas with the same table
names. How can I surpress table names (and views) from other schemas.
In ORACLE terms it seems to be using
select * from all_objects
where object_type in ('TABLE','VIEW')
order by object_name,owner
Do I have any control over this? Is there an Owner filter property?
regards
Andrew
In Query Wizard and Query Designer I get repeating of table names. I am
connecting to ORACLE and I do indeed have 3 schemas with the same table
names. How can I surpress table names (and views) from other schemas.
In ORACLE terms it seems to be using
select * from all_objects
where object_type in ('TABLE','VIEW')
order by object_name,owner
Do I have any control over this? Is there an Owner filter property?
regards
Andrew
This discussion has been closed.
Comments
- one option is to use the RB DataDictionary component to control what
tables and fields are available. For Oracle, I recommend setting
DataDictionary.UseTableOwnerName to true. If you install your ODAC plug-in
at Delphi design-time, you can configure the DataDictionary.BuilderSettings
to use your ODAC data connection and then launch the data dictionary builder
at Delphi design-time and generate the entries. Then delete the entries that
you do not want.
- The other option is to modify the Dade plug-in for ODAC, the GetTables
method, which is what is executing the sql that you showed in your post.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com