Hello,
I use an Oracle connection
LIB CONNECT TO 'Oracle_ora-dvl.xxxx (sd6_xxxx)';
LOAD JOUR,
ATELIER,
TYPE,
ARTICLE,
CELLULE,
EQUIPE,
CAUSE,
LIBELLE,
DESCRIPTION,
QUANTITE,
COUT,
COMMENTAIRE,
CREATION;
[ASV_REBUT]:
SELECT "JOUR",
"ATELIER",
"TYPE",
"ARTICLE",
"CELLULE",
"EQUIPE",
"CAUSE",
"LIBELLE",
"DESCRIPTION",
"QUANTITE",
"COUT",
"COMMENTAIRE",
"CREATION"
FROM "A3H34254"."ASV_REBUT";
I paste the script and I load about 900000 lines
I add a data filter in the connection definition to limit the number of lines CREATION > TO_DATE('2019-05-07 08:00:00','YYYY-MM-DD HH24:MI:SS') I see 204 lines
...
FROM "A3H34254"."ASV_REBUT" WHERE CREATION > TO_DATE('2019-05-07 08:00:00','YYYY-MM-DD HH24:MI:SS');
I paste the script then I load... 0 line !
When I want to use variable
Let dtMin = Timestamp#('2019-05-07 08:00:00','YYYY-MM-DD hh:mm:ss');
...
FROM "A3H34254"."ASV_REBUT" WHERE CREATION > $(dtMin);
An error occurs
Field 'JOUR' not found
I don't understand
Any idea ?