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.
