Calls the specified sql stored procedure and returns a dataset of the result Runs the query on the connectionID specified returned from the ACCONFIGFILE


Namespace: ctAC
Assembly: ctAC (in ctAC.dll)

Syntax

Visual Basic (Declaration)
<WebMethodAttribute(Description := "Custom SQL Call.", MessageName := "customSQLCallAlternateConnection"), _
 SoapHeaderAttribute("myCTACHeader", Direction := SoapHeaderDirection.In)>

Public Function customSQLCallAlternateConnection( _ 
   ByVal connectionID As String,  _ 
   ByVal sqlCall As String,  _ 
   ByVal inParms As nameValuePairs(),  _ 
   ByVal checkSum As String _ 
) As DataSet
C#
[WebMethodAttribute(Description = "Custom SQL Call.", MessageName = "customSQLCallAlternateConnection")]
[SoapHeaderAttribute("myCTACHeader", Direction = SoapHeaderDirection.In)]
public DataSet customSQLCallAlternateConnection(
   string connectionID,
   string sqlCall,
   nameValuePairs[] inParms,
   string checkSum
)
C++
[WebMethodAttribute(Description = L"Custom SQL Call.", MessageName = L"customSQLCallAlternateConnection")]
[SoapHeaderAttribute(L"myCTACHeader", Direction = SoapHeaderDirection::In)]
public:
 DataSet customSQLCallAlternateConnection(
   String connectionID,
   String sqlCall,
   array<nameValuePairs>^ inParms,
   String checkSum
) sealed 
J#
/** @attribute WebMethodAttribute(Description = "Custom SQL Call.", MessageName = "customSQLCallAlternateConnection") */
/** @attribute SoapHeaderAttribute("myCTACHeader", Direction = SoapHeaderDirection.In) */
public DataSet customSQLCallAlternateConnection(
   string connectionID,
   string sqlCall,
   nameValuePairs[] inParms,
   string checkSum
)
JScript
public 

   WebMethodAttribute(Description = "Custom SQL Call.", MessageName = "customSQLCallAlternateConnection")
   SoapHeaderAttribute("myCTACHeader", Direction = SoapHeaderDirection.In)
function customSQLCallAlternateConnection(
   connectionID : String,
   sqlCall : String,
   inParms : nameValuePairs[],
   checkSum : String
) : DataSet

Parameters

connectionID
sqlCall
inParms
checkSum

See Also