Passing parameter to a sql store procedure
Posted on 2013-12-22
I am trying to convert an access ADP continuous form that should be based on a parametized store procedure rather then just a view, and will be using a control on the form to pass the filter that is being build dynamically (according to users input) as a parameter to the store procedure, instead of using the server filter property of the form.
Now this worked amazingly fast, its just that I came across a major issue as follows,
when the filter string gets longer than approx. 500 characters, it does not get transferred properly to the server, resulting on the app hanging, and on the server side its constantly trying to execute the truncated sql statement...
therefore I am looking for a work around of this limitation..