Issue when running SQL from VB

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Issue when running SQL from VB

Author

Topic

CXXXV
Starting Member

12 Posts

Posted - 2009-05-29 : 20:11:54

When I run this query:

SELECT Sum(Schedule.QTY) AS SumOfQTY
FROM Schedule INNER JOIN (Route_Members INNER JOIN Routes ON Route_Members.ROUTE_ID = Routes.ROUTE_ID) ON Schedule.MEMBER_ID = Route_Members.MEMBER_ID
WHERE (((Routes.ROUTE_FREQ)='Weekly')
AND ((Schedule.DATE)>='5/25/2009' And (Schedule.DATE)<='5/29/2009'))
AND Schedule.MEMBER_ID= 14

it works fine in Management Studio. However, from VB it doesn't return anything.

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2009-05-30 : 02:17:07

Can you give the VB code you're using?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-30 : 02:51:30

quote:

Originally posted by CXXXV

When I run this query:

SELECT Sum(Schedule.QTY) AS SumOfQTY
FROM Schedule INNER JOIN (Route_Members INNER JOIN Routes ON Route_Members.ROUTE_ID = Routes.ROUTE_ID) ON Schedule.MEMBER_ID = Route_Members.MEMBER_ID
WHERE (((Routes.ROUTE_FREQ)='Weekly')
AND ((Schedule.DATE)>='5/25/2009' And (Schedule.DATE)<='5/29/2009'))
AND Schedule.MEMBER_ID= 14

it works fine in Management Studio. However, from VB it doesn't return anything.

are you using this as inline query in vb or are you wrapping this in procedure and then calling it? anyways would be better to show chunk of vb code which uses the above

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources