Impromptu Stored Procedure with Parameter

[Baquardie]

Hello,

I have a report in Impromptu 7.1.724. My report simply call a stored procedure. This works very well.

My problem is that now i need to add parameter so that my user will be able to filter data.

When I click on the button Query Data, then Insert Parameter, I enter information about my parameter (datatype string, type type in etc). When I'm done, i click OK, then Ok again. In my query line, Impromptu adds the string

?ParameterName?

at the end of my sql call to the stored procedure.

When I try to verify the syntax, I receive this error :

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-SS_SYNTAX, A syntax error was detected near ':'.

I don't understand what the error is. I do not have ':' in my sql call, do I? If someone has a clue about this one I would really appreciate.

Thank you all,

 

[Baquardie]

I found it. I searched over the PDF file on my machine and into the file impadmin.pdf there were the information needed.

Here is the right syntax for parameter :

call StoredProcedureName ( ?ParamName1? IN, ?ParamName2? IN)

Strangely, Impromptu just add the label ?ParamName1?, we have to add the ( ) and IN label...

Well now it's working.