Focal Point
Parameter list in SQL Wizard 7.1

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5311077622

May 06, 2007, 09:23 PM
Code Digger
Parameter list in SQL Wizard 7.1
Hi,

While using the SQL Report Wizard 7.1 I need to pass parameters (names and values) in comma delimited format. What is the exact way of doing it?

param1='val1', param2=val2

OR

param1, "val1", param2,val2

OR something else.

Please clarify.

Regards,
CD
May 07, 2007, 02:14 PM
Trav
Are you executing a stored procedure?

If so, it will look something like this:
-MRNOEDIT EX stored_proc '&val1', '&val2', val3 


In that example, val1 & val2 would be character strings of some kind and val3 would be a numeric.

Is that what you're asking?



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF