-
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
-
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
-
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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|