Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error calling a stored procedure

Hi guys..

Trying to run a fairly simple stored procedure from QV

QueryTable:

Load

*;

SQL $(vSQL);

I set my $(vSQL); in a button with action like:

= 'exec [DB].[dbo].[sp_trace] @batch = ' & chr(39) & vBatchID & chr(39)

vBatchID is set via inputbox.

The $(vSQL) ends up like:

exec [DB].[dbo].[sp_trace] @batch = '22081210212296004'

Running this from ms sql returns data.

But when I try to execute in QV I get this:

Error: File extdata.cpp, Line 2777

SQL EXEC [DB].[dbo].[sp_trace] @batch = '22081210212296004'

I do not see why????

Any advise

BR

Dan

4 Replies
MayilVahanan

HI

Please go through this link..

edit:

archanah, Johannes Sunden posts are help you.

http://community.qlik.com/thread/3223

or

try like this

LOAD *;

SQL EXEC sp_text '20100101','20100530';

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

Hi.

I have read that thread it provides no help to me at all.

I testet with

exec sp_who and that runs as it should.

MayilVahanan

HI

I tried with select statement in variable using action button and reload it.. it  works.

May be it helps..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
lukas_sokol
Contributor II
Contributor II

I have similar problem and when I use ODBC instead OLEDB Connect then it works.