Results 1 to 6 of 6

Thread: Recordset and referencing a field [Resolved]

Threaded View

  1. Jul 21st, 2003, 11:01 AM #1
    Maldrid
    Maldrid is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2003
    Location
    IL
    Posts
    739

    Recordset and referencing a field [Resolved]

    I am using an ADO recordset. Now there are several ways to reference a field within the recordset. Is there any difference in the way you do it? Is one way better than the other?

    VB Code:
    1. rs.fields("Field 1")

    2. rs("Field 1")

    3.  
    4. rs(0) 'I think this way would be the fastest since it doesn't

    5. 'have to do any comparison of the names in the fields. It knows

    6. 'to go straight to the first field in the recordset

    7.  
    8. 'there is one more way using the ! but I forget the syntax

    I was just wondering if any method is better.
    Last edited by Maldrid; Jul 21st, 2003 at 03:52 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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