topic Fetching data from stored procedure. in QlikView

Fetching data from stored procedure.

Mon, 24 Aug 2009 15:40:04 GMT

Hi All,

I could reload the script for fetching the data from my stored procedure Sample.

SQL

EXECUTE sample;

But am not able to see any available feilds out of it, and its showing blank , where as when am running the same SP am getting one value .

Could someone please help me out here?

Thanks,

Mahasweta

Mon, 24 Aug 2009 16:19:24 GMT

I would suggest do a few checks:

1) See if you are using ODBC or native driver. Try changing the connection to use either one.

2) Check for null values in stored proc resultset and if possible replace nulls with some default value.

Thanks

Amit

Tue, 01 Sep 2009 02:02:58 GMT

This heavily depends on the connection you are using.

I have made some tests on my machine:

- when using an ODBC-connection this does not work
- when using an OLEDB-connection this works

But as I said, this depends on your DB and the database-drivers ...

Which database are you using?

Best regards

Stefan