Field Name....Please Help


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Field Name....Please Help

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    Field Name....Please Help

    [Originally posted by Martin Miller]

    Hello there! You all have been a great help to me in the past, but I have another challenge for ya. Here it goes.... In my VB app. I'm connecting to an access DB via ADO and I want to retrieve some field names (ex. NAME, CITY, etc.). How would I go about doing this. I thought maybe it was in the method "fields" but I can't find out how to do it. (ex: recordset.fields.item(0)) Any help would be very much appreciated! Thanks in advance.

    -Marty

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Field Name....Please Help

    [Originally posted by Tim]

    You can do a number of different ways. It depends on what you want to accomplish. To do it the way you are showing here you would want to do something like:
    rs.fields(0).name

  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Field Name....Please Help

    [Originally posted by Martin Miller]

    That did it! Thanks a lot.

    Marty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center