>I've since gotten this to work the way I intended, but I wanted to update it to allow the user to search on two different fields if need be. How can I make it also look to another variable for the searching like the code below?
>
>
cmd = [exec InTransitRN ?']+fdBlNo+[']
>
>So basically I want them to be able use the above if they have that number, but also search on this one:
>
>
cmd = [exec InTransitRN ?']+fdRefNo+[']
>
>Is there a way to combine the two somehow or does it have to be done separately? Would a CASE statement work here? I was thinking of having it check to see which text box had data in it and use the associated code based on that. I don't know if that's a good way to do it though.
I'd just pass both fields as parameters, then modify the stored proc. to determine which query to use.
cmd = [exec InTransitRN ?fdBlNo, ?fdRefNo]
The only question would be will the user see both search fields, or just one of them at a time? Depending on the answer, you'll have to change the stored procedure accordingly. I'd just use an IF statement in the T-SQL to do this.