SELECT Like a Boss With Query Parameters

New Contributor III

2 years ago

Using the code sample from above

Using dbConn As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)

   Dim SqlQuery As String = "EXEC SP_API_CLIMATIQ_TRAVEL_FLIGHT @p_airport_1=" _
     & p_airport_1 & ", @p_airport_2= " & p_airport_2 & ", @p_passengers= " & p_passengers

   Dim dt As DataTable = BRApi.Database.ExecuteSqlUsingReader(dbConn, sqlQuery, True)

End Using

Is there a way to reference and use an OUTPUT parameter from a database stored procedure, in a business rule?

Blog Post

SELECT Like a Boss With Query Parameters