Trouble executing SQL Svr stored procedure - "...Must set a value to the Out1 Param
Question

I'm very new and know this is a simple question, but getting the first few applications built is challenging.

I have an existing SQL stored procedure that returns a data set. (It cannot be a view due to it's complexity).

I created a entity to store the results:


I built a screen to display the data, as well as a Data Action to run the SQL:


I cannot get rid of the error: GetRuntimes must set a value ot the Out1 Parameter, even though I have this:


Thanks

@Doug Kantor

Make sure you are not missing input parameter. 

Output parameter datatype is "OvernightRuntimes List" then assign Sql.list to that parameter.
you are selecting current record.

I am attaching screenshot for your reference,

Thanks,

Shriyash

Thanks for the reply. It helped and I have it working!

Please mark as solution so that post will close.

Cheers

Please mark as solution so that post will close.

Cheers

I think output does not need to be list type, it will be enough if it will have entity type  OvernightRynTimes

Thanks for the reply. It helped and I have it working!

@Doug Kantor

Make sure you are not missing input parameter. 

Output parameter datatype is "OvernightRuntimes List" then assign Sql.list to that parameter.
you are selecting current record.

I am attaching screenshot for your reference,

Thanks,

Shriyash

Thanks for the reply. It helped and I have it working!

Please mark as solution so that post will close.

Cheers

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.