Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help about select statement

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

2 Replies
biester
Specialist
Specialist

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

tabletuner
Creator III
Creator III

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