S Sunny New Member Jun 27, 2013 #1 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 ?
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 B4X founder Staff member Licensed User Longtime User Jun 28, 2013 #2 For some reason you appear as an unlicensed user in the forum. Please contact [email protected] in order to fix it. Upvote 0
For some reason you appear as an unlicensed user in the forum. Please contact [email protected] in order to fix it.
