Hi,

I am trying to design a simple form, where we type a number and it looks up that data in a stored procedure located in SQL. 

The place where I am having difficulty understanding is:

When adding that variable from the Form and trying to take it and enter it in Stored Procedure, the value does not show up and leaves an empty {{}}

I am trying to do this in two pages of the form, where one place they enter the data and the other it shows it, the procedure works as I have tested it on SQL - the char is a nvarchar in SQL. 

Maybe I need to convert it, but unable to configure that functionality, if anyone knows how to perform this task. 

Please let me know as I have been having a lot of difficulties locating this info online. 

Thanks in Advance.