Adding more to this.
I found this, with no answer. But this is my problem as well.
I'm trying to connect to a SQL Server DB to automatically fill certain form fields. I can create the connection, but then I am presented with a screen to select the data collection method - either Table, Stored Procedure, or SQL Query. I choose Stored Proc, but when I try to proceed I get the following error:
Stored Procedure has non-optional parameters.
How do I pass the stored procedure the parameter?
Here is my SP
SELECT [Name]
FROM List2
WHERE [File] = @Numb
Thanks!
Jim