October 9, 2008 at 7:08 am
I have an Application which uses ACCESS and VB and SQL.
Im having an issue in the front end some Im having to run the Store Procedure in the back-end just as a work around, the following is what im trying to run:
execute procSalesReportsMMCommBySector '2008 Sep 01', '2008 Sep 30',NULL,Null,Null,Null,Null,Null,Null,Null
The first Null in the front-end is a drop down list wherebny one option is 'NOT LIKE ZAR', how can I run this in the back end?
Iv tried NOT LIKE ZAR... didnt work
Thanks
October 9, 2008 at 7:26 am
Don't understand your question completly but if you're asking how to use the like-clause in SQL server the answer is
not like 'ZAR%'
October 9, 2008 at 8:10 am
it calls a stored procedure at your sqlserver instance.
connect using QueryAnalyser and execute this :
execute sp_help procSalesReportsMMCommBySector
I expect it to have a number of input parameters (at least 10) (one for each value you supplied)
execute procSalesReportsMMCommBySector '2008 Sep 01', '2008 Sep 30',NULL,Null,Null,Null,Null,Null,Null,Null
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy