| Subject | Re: [firebird-support] Problem with where clause |
|---|---|
| Author | |
| Post date | 2018-01-05T13:35:04Z |
Now with
V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND '''||:TO_DATE||'''';
It works for me and I tried with
V1=:V1 || ' WHERE CF.DATE_COMMANDE>='''||:FROM_DATE||''' AND CF.DATE_COMMANDE<='''||:TO_DATE||'''';
It works too. In which case this isn't the right solution ?