-
return <blank> tag
hi
through my stored procedure i m returning such a string
Code:
SET @vsResult = 'SUPPLIER CODE / ' + ISNULL(CONVERT(VARCHAR,@vnSupplierID),'<BLANK>')
SET @vsResult = @vsResult + ' ' + 'PRODUCT CODE / ' + ISNULL(CONVERT(VARCHAR,@vsProductCode),'<BLANK>')
SET @vsResult = @vsResult + ' ' +'GL CATEGORY CODES / ' + ISNULL(CONVERT(VARCHAR,@vsGLCategoryCode),'<BLANK>')
SET @vsResult = @vsResult + ' ' + 'RESULT: '
in my procedure its returning string as i expected.but problem is in my vb it does not showing <BLANK> TAG.
Code:
With mobjDatabaseReader
.SPRun msMsgStoreConnection, _
SP_BULKIMPORT_PRODUCTGLCATEGORYDATA, _
.MakeParameter("@vnMemberID", adtInteger, apdParamInput, , vlSender), _
.MakeParameter("@vnSupplierID", adtInteger, apdParamInput, , asLineCols(lCount, 0)), _
.MakeParameter("@vsProductCode", adtVarChar, apdParamInput, 50, asLineCols(lCount, 1)), _
.MakeParameter("@vnIsStock", adtInteger, apdParamInput, , IIf(asLineCols(lCount, 2) = "Y", 1, 0)), _
.MakeParameter("@vsGLCategoryCode", adtVarChar, apdParamInput, 1000, asLineCols(lCount, 3)), _
.MakeParameter("@rsResult", adtVarChar, apdParamOutput, 1000), _
vsResult
End With
what could be problem.
thanks