Stored Procedures

[#1]

Anybody knows how to use SQl stored procedures in the QV Script?

Thanks

[garystrader]

SQL EXEC myProcName;

Assuming the stored procedure returns a record set, you will be able to LOAD them into a table in your app.

Anything after the SQL keyword is treated as pass-through SQL and not interpreted by QlikView.  It has to follow the SQL syntax of the source database system.

[#3]

Hi Gary,

do you have any example or article contains any example for that?

would appreciate

thanks,

David

[garystrader]

I gave an example.  Are you having a specific problem?  Also, search the forums - there are other threads with solutions for this.

[#5]

Hi Gary,

Sorry i was fast-reading your answer, and thought there might be any full scale example LoL

Btw, thanks anyway

[rbecher]

Hi Badr,

what is the database system? What kind of return parameter of the SP (if any..)?

- Ralf

[#7]

Thanks Gary... We've used this now and it works well