topic Help about select statement in QlikView

Help about select statement

Wed, 19 Aug 2009 08:06:19 GMT

I am running a SELECT command to retrieve records from SAP tables using an OLEDB, using Qlikviw Demo 8.5 version. But after clicking F5 (run) the system returns a MsgBox with a message about an error in the instruction SLQ (error MDX). A example select statement:

CONNECT....;
SELECT * FROM `EBAN`;

Forgot a command? How can I fix?

Regards

AW:Help about select statement

biester — Wed, 19 Aug 2009 12:13:43 GMT

Hi,

what exactly is the error? Does the error persist if you try to select specific fields instead of "SELECT *" - such as "SELECT FIELD1,FIELD2 FROM EBAN;"

Rgds
Joachim

Help about select statement

tabletuner — Wed, 19 Aug 2009 15:22:17 GMT

Have you tested the OLEDB datasource connection in windows configuration system thorougly?