Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jun 2002
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    viewing results of query problem

    Hi,

    I am trying to view the results of a query. Some snippets of my code:

    SQL = "SELECT * FROM "& ptype &" WHERE pallet_no = 'US337+" & pal &"'

    RS = DBconn.Execute(SQL)"


    Now when I try to say something like RS.EOF, or RS. anything it gives me the error:

    "Object doesn't support this property or method: 'EOF' "

    Is there something I am missing?

    Any help would be appreciated

    Darksbane

  • #2
    New Coder
    Join Date
    Jun 2002
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Figured it out should have had

    SET RS = DBconn.Execute(SQL)

  • #3
    Senior Coder
    Join Date
    Jun 2002
    Location
    Wichita
    Posts
    3,880
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Did you create RS as a recordset object? If not then it's still just an ordinary variant.

    set RS = System.CreateObject("ADODB.Recordset")


  •  

    Posting Permissions

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