DIRECT SELECT Problem

[#1]

Hi everybody,

who can tell me why a so simple script doesn't load anything from "Test.Employes" table ?

ODBC CONNECT32 TO phpmyadmin;          //  MySQL  Database

DIRECT SELECT

    nom            as Nom_FromTest,

    matricule    as %E,

    matricule,

    `date_in`,

    `date_out`

FROM test.employes;

Emp:

LOAD    EmpID            as %E,     

        EmpID,     

        Prénom,     

        Nom,     

        Fonction

FROM emp.xls

(biff, embedded labels, table is [Sheet1$]);

Here is the log file where we can see no lines are loaded from DIRECT TABLE.  It should load 2 lines

08/11/2013 09:50:28:       DIRECT SELECT

08/11/2013 09:50:28:           nom            as Nom_FromTest,

08/11/2013 09:50:28:           matricule    as %E,

08/11/2013 09:50:28:           matricule,

08/11/2013 09:50:28:           `date_in`,

08/11/2013 09:50:28:           `date_out`

08/11/2013 09:50:28:       FROM test.employes

08/11/2013 09:50:28:           5 champs trouvés: Nom_FromTest, %E, matricule, date_in, date_out, 0 lignes récupérées

Emp table loads correctly

QV Version : 11.20.12018.0 SR3  64bits

thank you for your help

Chris

[#2]

You can include as many connections (ODBC, OLEDB, etc.) as you want.

For Direct Discovery QlikView takes the previous one to the DIRECT sentence to run the queries during analysis time.

[#3]

Muchas gracias Juan

Hasta la vista

Chris