ExecuteScalarQuery

This BRAPI returns the first column in the first row of a dataset. It can be used to return a scalar when used as a remote business rule.

Here is the rule in C#:

Copy 
    string sqlExecStatement = "SELECT COUNT(*) FROM InvoiceMaterialDetail";

    using (DbConnInfo dbAXConn = BRApi.Database.CreateRelayDbConnInfo(si, "{GatewayName}"))
    {
        long intResult = BRApi.Database.ExecuteScalarQuery(dbAXConn, sqlExecStatement, 90);
        dbAXConn.Close();
    }

Here is the rule in VB:

Copy 
Dim sqlExecStatement As String = "SELECT COUNT(*) FROM InvoiceMaterialDetail"

Using dbAXConn As DbConnInfo = BRApi.Database.CreateRelayDbConnInfo(si, "{GatewayName}")
    Dim intResult As Long = brapi.Database.ExecuteScalarQuery(dbAXConn, sqlExecStatement, 90)
    dbAXConn.Close()
End Using