Calling a stored procedure via an If statement

Wed, 27 Aug 2014 13:46:32 GMT

Hi Guys,

I'm after some help calling a stored procedure via an if statement in the load script.

In isolation SQL EXEC dbo.sp_add_log 1, 'Qlikview-Agent Performance', 'procedure started' works fine but I only want it to run when the if statement is fulfilled (ie document path starts C;\QV_)

When the if statement is not fulfilled, I'd want to bypass this stored procedure call and go on to run the rest of the script starting on the next tab. This just stops if the document path does not start C:\QV_

What am I missing?

if left(DocumentPath(),6) = 'C:\QV_' then

SQL EXEC dbo.sp_add_log 1, 'Qlikview-Agent Performance', 'procedure started';

Thanks

Re: Calling a stored procedure via an If statement

Wed, 27 Aug 2014 14:24:42 GMT

Don't worry..Sorted it!

if left(DocumentPath(),6) = 'C:\QV\' then

SQL EXEC dbo.sp_add_log 1, 'Qlikview-Agent Performance', 'procedure started';

end if

Missed the End If.

topic Re: Calling a stored procedure via an If statement in QlikView

Calling a stored procedure via an If statement

Re: Calling a stored procedure via an If statement