SQL and Visual Basic question.

[Bob]

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

[Q*bert]

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

[Bob]

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
>