Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field Not found - while calling store procedure

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

AS

begin





2 Replies
Not applicable
Author

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!

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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...