D
dubnet
Guest
is there an sql query to retrieve the attributes of a table?
- Local time
- Today, 05:30
- Joined
- Feb 28, 2001
- Messages
- 30,933
All such queries would represent implementation-dependent features. I think the ANSI standard says the answer is NO.
In Access, the answer is NO because SQL queries tables but you want to query a TableDef, which is NOT a table in Access.
Now, there might still be a way - but you would have to write some module code to do it. If you wrote a function that could be given a parameter and return a table property, and if the function was declared public, you could use it in a query.
Unless you are using this for documentation, I see no need for such a query. You cannot do much with the table's definitional data in a query context. If you could get the data into a table or query, you still would not be able to do much with it. On the other hand, direct lookups in a module can make the data available in a context where you could actually use it.
In Access, the answer is NO because SQL queries tables but you want to query a TableDef, which is NOT a table in Access.
Now, there might still be a way - but you would have to write some module code to do it. If you wrote a function that could be given a parameter and return a table property, and if the function was declared public, you could use it in a query.
Unless you are using this for documentation, I see no need for such a query. You cannot do much with the table's definitional data in a query context. If you could get the data into a table or query, you still would not be able to do much with it. On the other hand, direct lookups in a module can make the data available in a context where you could actually use it.
D
dubnet
Guest
I do have a practicle use for this situation, that is that if an administrator is given rights to add attributes to a table then, the user view should automatically reflect this. for example if a front end has been written that contains a search option, then the return-query can be used to create the relevant search fields. I am using ColdFusion as the middleware and Flash the front-end. Is there any way cf can help?
D
dubnet
Guest
wow!...that is a bit over my head. Could you relate it to a specific example...say...there is a table called myTBL which holds userID and userName. How can I query this table to retrieve the attributes (userID and userName), considering they can be added or removed by another user.
D
dubnet
Guest
.
Similar threads
