troubleshooting Question

Error Detected by Database DLL - On Change of SP Parameter

Avatar of feesu
feesu asked on
Crystal Reports
8 Comments1 Solution294 ViewsLast Modified:
Experts,
I've got this code. It works fine when my parameter is "101". Gives me an "Error detected by database dll" error when i expand the parameter like "101 OR Cln_SerialNo=102 OR C ...

        Dim crDBTables As CRAXDRT.DatabaseTables
        Dim paramValueInfos As New ParameterValueInfos
        Dim paramValueInfo As New ParameterValueInfo
        Dim paramValues As New ParameterValues
        Dim paramValue As New ParameterValue
        paramValue.StartValue = 0
        paramValue.EndValue = 0
        paramValues.Add paramValue
        paramValueInfo.parameterName = "@ClientID"
        paramValueInfo.ParameterValues = paramValues
        paramValueInfos.Add paramValueInfo
        Set crDBTables = m_Report.Database.Tables
        crDBTables.AddStoredProcedure "Client_Profile_Get_ByClient", , , 2, "p2ssql.dll", "SRVSQL", , "GLOBAL", "sa", "sa", paramValueInfos
        m_Report.ParameterFields(1).AddCurrentValue "101 OR Cln_SerialNo=102 OR Cln_SerialNo=103 OR Cln_SerialNo=104"
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros