|
-
Feb 29th, 2012, 12:13 PM
#6
Thread Starter
Member
Re: Getting the column name that appears to the user
 Originally Posted by TysonLPrice
I'm on MS SQL but I think you need to do the leg work yourself. I don't see how the database can know what aliases you are using in queries and VB code unless they were actually assigned on the DB (if possible).
I'd be interested to know if it can be done with a simple report.
In fact, the names are assigned on DB and I need to get them in my app using VB code. It´s possible to get real/internal names but I don´t know how to get the names that appears to the user. That´s the problem.
If I create that list I have mentioned before and in the future someone (or myself) changes the DB, then I will need to remember to update that list. That´s why I´m trying to avoid creating that list.
Last edited by jalexm; Feb 29th, 2012 at 12:17 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|