Re: Passing parameter to secondary data connection

Hilary Stoupa — Wed, 30 Jul 2008 17:24:18 GMT

Have you seen this post using jscript? Or this, which uses SQL 2005 web services?

Passing parameter to secondary data connection

dlgross — Wed, 30 Jul 2008 15:02:51 GMT

I'm using IP 2003. I would like have my users type in a Project Number and then send this value to a SQL Server DB to get existing project data that will then populate several read only fields on the form (for reference purposes). I have created a rule the runs a data connection which calls a View and then filter the results with the Project Number value that the user entered into a text box. This works but it is very slow (10-15 seconds). I'm thinking that I might be able to get better performance if I passed the project number parameter to a stored procedure, but I don't know how to create a Data Connection to stored procedure. It seems that I can only do this with a table or a view. What am I missing? Could someone please tell me if I'm on the right track and what I need to do or give me another option that will provide better peformance.

Thanks

Dean

Data Connections

Re: Passing parameter to secondary data connection

Passing parameter to secondary data connection