SQL and Visual Basic question.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: SQL and Visual Basic question.

  1. #1
    Bob Guest

    SQL and Visual Basic question.


    Could someone please explain to me why the ExecuteSQL() sub will work in Devx's
    project code, but not mine. A while ago, it would capitalize the e,s,q,
    and l when I'd finished typing it. Now it doesn't even to that. I have
    the 2.1 objects lib included. All I'm wanting to do is run a simple query,
    but it says Sub or Function not Defined.
    Any help is greatly appreciated,
    -Bob

  2. #2
    Q*bert Guest

    Re: SQL and Visual Basic question.


    It might help to display the connection code you use as well as a case where
    it is not working

    set rs = conn.execute(SQL)
    usually works for me

    "Bob" <blah@lbah.com> wrote:
    >
    >Could someone please explain to me why the ExecuteSQL() sub will work in

    Devx's
    >project code, but not mine. A while ago, it would capitalize the e,s,q,
    >and l when I'd finished typing it. Now it doesn't even to that. I have
    >the 2.1 objects lib included. All I'm wanting to do is run a simple query,
    >but it says Sub or Function not Defined.
    >Any help is greatly appreciated,
    >-Bob



  3. #3
    Bob Guest

    Re: SQL and Visual Basic question.


    Well, thanks, but (call me an idiot) turns out Devx wasn't displaying all
    of the code; ExecuteSQL was a prewritten procedure that I wasn't seeing.




    "Q*bert" <luke_davis_76@hotmail.com> wrote:
    >
    >It might help to display the connection code you use as well as a case where
    >it is not working
    >
    >set rs = conn.execute(SQL)
    >usually works for me
    >
    >"Bob" <blah@lbah.com> wrote:
    >>
    >>Could someone please explain to me why the ExecuteSQL() sub will work in

    >Devx's
    >>project code, but not mine. A while ago, it would capitalize the e,s,q,
    >>and l when I'd finished typing it. Now it doesn't even to that. I have
    >>the 2.1 objects lib included. All I'm wanting to do is run a simple query,
    >>but it says Sub or Function not Defined.
    >>Any help is greatly appreciated,
    >>-Bob

    >



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