Results 1 to 9 of 9

Thread: Getting the column name that appears to the user

Threaded View

  1. #6

    Thread Starter
    Member
    Join Date
    Feb 2012
    Posts
    35

    Re: Getting the column name that appears to the user

    Quote Originally Posted by TysonLPrice View Post
    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
  •  



Click Here to Expand Forum to Full Width