I am getting an error "???errors.invalidParameters???" when attempting to execute a SQL Function.
Here is my sQL select statement for my function:
SELECT * FROM [dbo].[p3_labor] (
<@inv_mast_uid, int,>)
GO
a!executeStoredProcedureForQuery(
dataSource: cons!POO_P21_Connection,
procedureName: "p3_labor",
inputs: a!storedProcedureInput(
name: "inv_mast_uid",
value: 114530
)
)I'm not sure a!executeStoredProcedureForQuery() can access functions. It would be neat if it could, though.
In case this makes any difference: if the procedure's input variable is "inv_mast_uid", then from what i've seen, it should be referenced inside the procedure without the "@" character. Though I should disclaimer that I'm not thoroughly versed in all styles of syntax that can be used in procedures, so I could be assuming incorrectly here.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.