Peculiar Table Not Found error

[deekshith_juvva]

Hi,

I'm kind of a beginner with QlikView. I'm trying to query a MySQL database to get around 50000 rows. I get the 'Table Not Found' error using the following code:

RawData:

SELECT *

FROM MyTable;

STORE RawData into ..\Data\RawData.qvd (qvd);

But not if I use the following code:

RawData:

SELECT *

FROM MyTable

LIMIT 10;

STORE RawData into ..\Data\RawData.qvd (qvd);

Any idea how to fix this?

Thanks,

Deekshith

Message was edited by: Deekshith Juvvadi

[kaushiknsolanki]

Hi,

Your script should be

RawData:

SELECT *

FROM MyTable;

STORE RawData into ..\Data\RawData.qvd (qvd);

But not if I use the following code:

RawData:

SELECT *

FROM MyTable

LIMIT 10;

STORE RawData into ..\Data\RawData.qvd (qvd);

Because Store will look for the Table Alice name which you have given, not the actual name of the table.

Regards,

Kaushik Solanki