topic Field Not found - while calling store procedure in QlikView

Field Not found - while calling store procedure

Thu, 16 Sep 2010 15:30:16 GMT

Hi,

I am new to QlikView. I am trying to get data from stored procedure.

While it is working for the script using select statement, it is giving Field not found - <A> error message when I am calling the stored procedure. Please can someone help me to proceed with this.

Working script:

LOAD A,B;

SQL SELECT A, B FROM test

Script that is giving error:

LOAD SELECT A, B FROM testA,B;

SQL EXEC

QlikView_Test_Sample;

The corresponding Stored procedure:

end

Thanks in advance

CREATE procedure QlikView_Test_Sample

begin

Field Not found - while calling store procedure

Tue, 12 Apr 2011 22:29:17 GMT

It looks like you mis-pasted your code in your post, making it difficult to understand. If you fix it, you may get some responses. I hope so, because I have a very similar problem!

Field Not found - while calling store procedure

Oleg_Troyansky — Wed, 13 Apr 2011 01:18:10 GMT

it's tricky when you copy code from specialized Code editors (including QlikView Script Editor... Try to paste your code into Notepad and then copy it and baste it into the forum post...