Hidden Tables and Queries

[Amy Blankenship]

Hi, all;

I'd like to hide my tables in the main Tables window and just access them
from custom Groups to make it easier for other developers to find the tables
they need for a given type of data. However, when I do that, the tables are
not visible from the Queries interface.

I can make the hidden tables show in the Queries by showing hidden objects,
but that then makes the tables visible, albeit grayed out, in the Tables
window.

Is there any way to show tables in an organized fashion without hiding them
from the query builder?

Thanks;

Amy

 

[Amy Blankenship]

Is this the wrong forum to address this question to? If so, could someone
please direct me to the correct forum?

Thanks;

Amy

 

[Tim Ferguson]

Other "developers" should be well able to cope with a screen full of
tabledefs; if you have provided an alternative structure in custom groups
then sensible people should be able to take advantage of that too. I
don't see the point of trying to invisiblise the things in the normal
place to look.

If you have a big reason for trying to manipulate the UI like this, you
could remove all the tabledefs from the front end (you are using a split
structure, aren't you) and replacing all the queries with direct
connections as in

SELECT This, That, TheOther
FROM SomeTable IN [d:\etc\tables.mdb]

or whatever.

For users, it's normal to hide the entire database window and expose the
objects you want them to see in your own UI structure.

Is this the wrong forum to address this question to? If so, could
someone please direct me to the correct forum?

Well, it's not really a db design issue, but I'm not sure where else you
would go either.... possibly m.p.a.setupconfig but I don't really know
what goes on there.

Hope that helps


Tim F

 

[Amy Blankenship]

Other "developers" should be well able to cope with a screen full of
tabledefs; if you have provided an alternative structure in custom groups
then sensible people should be able to take advantage of that too. I
don't see the point of trying to invisiblise the things in the normal
place to look.

You'd think so, but I have my doubts. The databases I've gotten from these
developers aren't terribly sophisticated.

If you have a big reason for trying to manipulate the UI like this, you
could remove all the tabledefs from the front end (you are using a split
structure, aren't you) and replacing all the queries with direct
connections as in

SELECT This, That, TheOther
FROM SomeTable IN [d:\etc\tables.mdb]

or whatever.

That sounds unnecessarily complicated and not very portable.

For users, it's normal to hide the entire database window and expose the
objects you want them to see in your own UI structure.

So you're saying that you can't hide the tables in the table window and have
them available in the query builder both?

I suppose building my own UI would not make the tables visible in the query
builder, either, so that's not really going to help much, really.

Probably the best solution is to tell them to look in the groups I've
defined if they want to see them categorized, otherwise just view the whole
list.

Well, it's not really a db design issue, but I'm not sure where else you
would go either.... possibly m.p.a.setupconfig but I don't really know
what goes on there.

Thanks. Where can I go to request this feature in a future version?

Thanks;

Amy