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