You are viewing limited content. For full access, please sign in.

Question

Question

stored procedure does not have input parameter/column

asked two days ago Show version history

Stored Procedure newbie.  I created a stored procedure in SQL database.  I've connected the datasource. however, when using lookup rules to pull in the data, there are no input or columns like how tables/views are created.  

 

my goal is to use look up rule so that if the user enters a call_number, the aggregated_notes will fill in a field called "1 mult" associated with that call_number.

 

 

0 0

Answer

SELECTED ANSWER
replied two days ago

so i fixed my stored procedure SQL to include a parameter to fill in the comment section based on call_number. after changes, it worked perfectly.

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.