Log in to AnswerLog in to Follow
UserImage.jpg
Doug Kantor
15Views
5Comments
Solved
Trouble executing SQL Svr stored procedure - "...Must set a value to the Out1 Param
Question
SQL

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

0
0
18 Jul

@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

See solution in context
1
0
20 Jul

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

1
0
20 Jul

Replying to Doug Kantor's comment on 20 Jul 2022 18:18:44

Please mark as solution so that post will close.

Cheers

0
0
21 Jul

Replying to Doug Kantor's comment on 20 Jul 2022 18:18:44

Please mark as solution so that post will close.

Cheers

See solution in context
0
0
21 Jul

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

1
0
19 Jul

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

0
0
20 Jul

@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

1
0
20 Jul

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

1
0
20 Jul

Replying to Doug Kantor's comment on 20 Jul 2022 18:18:44

Please mark as solution so that post will close.

Cheers

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