I have a stored procedure that builds a select statement by using variable handed to it from a VB6 program. The procedure first uses the variables to pull summed money data into several other variables declared in the proc. Then it uses those variables to build a select statement that will return a recordset to be used by the VB6 program in a Crystal report. The variable causing the problem is used twice. In the first part where it is used in the Where clause for specific lines on an order is where the issue is. There is already an order number variable used it works fine until I add the line number variable. If I hard code the line numbers in, it works but when I plug the variable in it returns nothing. In the second part where the Select is built the variable works fine. I have attached the entire SP. The variable is @RecNos. The order number and line or record numbers are both text.
Start Free Trial
