Error when selecting condition in Oracle query

vthibaut — Thu, 09 May 2019 13:57:40 GMT

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 ?

topic Error when selecting condition in Oracle query in App Development

Error when selecting condition in Oracle query