Passing query template name to BLS SQL action in the link editor

65 Views

I want to have one transaction that uses the SQL query action, but which query template it uses will be dependent on some user input. I am having trouble passing the query name. I'm using the full file path in xml format (i.e. "c://<folder1>//<folder2>//<folderN>//"&PassedFileName&".xml", but with backslashes instead of forward slashes). I got an error around the connector, so I set that too. Then I got an error around mode, so I set it to "FixedQuery". Now I'm getting, "The Query expression was not set with the Query parameter".

There are only 3-5 possible queries that will be used, so I'd rather build SQL queries and just pass the transaction the name of the query, as opposed to passing the full text of the query each time.

Thanks,

Carrie

Edited by: Carrie Schimizzi on May 9, 2008 6:38 PM

Edited by: Carrie Schimizzi on May 9, 2008 6:39 PM

Edited by: Carrie Schimizzi on May 9, 2008 6:40 PM