Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue storing data called from a stored procedure into a .Qvd. If I just load from the stored procedure with the SQL EXEC Stored_procedure; I get the data correctly loaded. Its only when I add the Store... into... (qvd); statement afterwards that my data fails to load.
Any input?
Double check your store statement as that was my problem.
Hi,
Check this
[Data]:
SQL EXEC Stored_procedure;
STORE [Data] INTO Data.qvd;
DROP TABLE [Data];
Regards,
Sokkorn Cheav
it can be that the store path you have given is not reachable by Qlikview. So, just check your path.
To check if it is storing properly, you can verify with just
store data into data.qvd(qvd);
It will store your qvd into the current directory.
Also, if there is already a qvd file with same location in where you are trying to store your qvd, just delete that file because sometimes that file may be locked for writing and so is not able to be replaced with new generated qvd.
let me know, if problem still persists.
...
Ashutosh
you can write like this;
data:
load [data fields];
sql execute [Store_Procedure];
Dont forget to add in your connection string "mode is write"
also in your connection settings check boxes should be checked (read/write mode and ececute 3rd party programs). It should be worked, I tested with no problem.
good luck,
Murat
Thank you. Its worked.
Regards,
binu