Need Help With Query !@!

[Sunny]

Hello,

I was wondering what I'am doing wrong.

Step 1. So I have this query where I want to get a count :
Query = "SELECT COUNT(*) As PrCount" & CRLF & _
"FROM [dbo].[OE_PICKINGSLIP_Details]" & CRLF & _
"WHERE [PickingSlipNo] = " & OrderNo

Step 2. My connection is good and I'am able to execute the Query there are no error messages.
res=conn.ExecuteQuery(Query)

step 3. This is where it gives me an error
intNbProduct = conn.ReadField("PrCount")

Error Message : Error Parsing #ERROR# as a number

What exacly am I doing wrong ?

 

[Erel]

For some reason you appear as an unlicensed user in the forum. Please contact [email protected] in order to fix it.