Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview does not recognise Direct Discovery Syntax

I tried to use the Direct Discovery Method under QlikView 11.2 with the following syntax:

ODBC CONNECT32 TO [MS Access Database;DBQ=\\ksafsp01\KSAGDAT\IT\01_Alle\001_Projekte\610_SmartScanning\Abgespeicherte_Dokumente.accdb];

Direct QUERY

DIMENSION

Lieferscheinnummer

MEASURE

Datum

FROM tblUnterschriebene_Speditionsaufträge;

I looked through several forum-entries and tried it with different databases without success.

Qlikview somehow does not recognise the Syntax because "DIRECT" becomes blue but "QUERY" not.

I am using QlikView Private edition version 11.2. Is this the problem? Furthermore, when opening a qlikview file, I have a choice between two qlikview versions:

Both versions do not succeed with the direct query syntax.

1 Reply
swuehl
MVP
MVP

I think the DIRECT QUERY syntax was introduced in a version later than 11.20 IR, AFAIR, DIRECT SELECT was used before that. There were also other syntax changes at that time.

To make it short, I would recommend to use a recent version of QV (11.20 IR is years old, and I don't want to talk about 11.00 SR1...)