Discuss "tag is not displaying in vb" in the Visual Basic Programming forum.

guddu · #1 July 17th, 2008, 11:19 AM

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

jmurrayhead · #2 July 17th, 2008, 11:24 AM

How are you displaying it in VB?

guddu · #3 July 17th, 2008, 11:52 AM

like this
vsAllResults = vsAllResults & vsResult & vbNewLine

jmurrayhead · #4 July 17th, 2008, 12:22 PM

Okay, but how is it output to the user? popup box? Is it assigned to a Visual Basic form value? Is this being used in conjunction with ASP?

What happens if you replace '<blank>' in your stored procedure with 'testing'?

guddu · #5 July 17th, 2008, 12:28 PM

this output goes to in a txt file.and let me check for this
What happens if you replace '<blank>' in your stored procedure with 'testing'?

guddu · #6 July 18th, 2008, 04:57 AM

yeah JMH u are rite
What happens if you replace '<blank>' in your stored procedure with 'testing'?

i chnaged <blank> with 'testing' but even testing also not getting.but in analyzer i m getting.what the hail going on?

Any idea?
thanks

guddu · #7 July 18th, 2008, 05:36 AM

guys gotted now.actaully from my dll i was passing blank and in my procedure checking for null.
now changed in vb blank to null.

JMH thanks a lot

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Webchart Control not displaying in Firefox	richyrich	.Net Development	1	June 2nd, 2008 01:43 PM

Discuss "tag is not displaying in vb" in the Visual Basic Programming forum.

Visual Basic Programming - Learn coding practices and tips to get the best out of your Visual Basic applications. Visual Basic was developed by Microsoft for building stand alone Windows based applications.