Normally, a query would contain something like: WHERE CF.DATE_COMMANDE BETWEEN '1.1.2018' AND '2.1.2018'
What you are doing is forgetting the apostrophes and trying to use: WHERE CF.DATE_COMMANDE BETWEEN 1.1.2018 AND 2.1.2018 which correctly receives a syntax error. I can think of three ways to fix this: Either V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND '''||:TO_DATE||''''; or (named parameters): V1=:V1 || ' WHERE CF.DATE_COMMANDE BETWEEN :MY_FROM_DATE AND :MY_TO_DATE'; FOR EXECUTE STATEMENT (V1) (MY_FROM_DATE := FROM_DATE, MY_TO_DATE := TO_DATE) INTO ... or (positional parameters): V1=:V1 || ' WHERE CF.DATE_COMMANDE BETWEEN ? AND ?'; FOR EXECUTE STATEMENT (V1) (FROM_DATE, TO_DATE) INTO ... HTH, Set 2018-01-05 12:58 GMT+01:00 Köditz, Martin [email protected] [firebird-support] <[email protected]>: > > > Hi, > > > > I think there is a quote missing at the end of „:TO_DATE“; > > > > Regards > > Martin > > > >
