SPONSORS:






User Tag List

Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    May 2002
    Location
    France
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Get Column description in DB

    Hello,

    I would like to get the column description in a DB (SQLDescribeCol) but i don't how to do or if it's possible with Silk.

    Thanx

    ------------------

  2. #2
    Senior Member
    Join Date
    Jul 1999
    Location
    Bellingham, WA USA
    Posts
    1,323
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Get Column description in DB

    Hey Rascal...

    I'm guessing you want the "label" or "heading" of the columns in your table, no?

    You should be able to do this with something like:

    ------------------

  3. #3
    Junior Member
    Join Date
    May 2002
    Location
    France
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Get Column description in DB

    thanx for the answer DJGray but it's not what I wanted ;-)

    I want to get the desciption of a column in a DataBase. I search in DBTester functions but nothing seems to get the good infos because none of the functions use "SQLDescribeCol" but i hope i'm wrong

    ------------------

  4. #4
    Senior Member
    Join Date
    Jul 1999
    Location
    Bellingham, WA USA
    Posts
    1,323
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Get Column description in DB

    Oh... "duh!" I just reread your original post. Sorry. My bad.

    ------------------

  5. #5
    Senior Member
    Join Date
    Aug 2001
    Location
    Manchester, NH
    Posts
    121
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Get Column description in DB

    I don't know how or if you can get SQLDescribeCol to work (sorry no help there), but if you want to get column attributes, like column type, length, etc yu can get that another way. In a MSSQL db that information is stored in syscolumns, and I believe other dbs have an equivalent table that stores that info. Since the information is in a table, you can access that through the standard DB_ExecuteSQl function. Just a thought.

    ------------------
    Adam Kuczkowski
    akuczkowski@frametech.com

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 10:39 PM.

Copyright BetaSoft Inc.