| Subject | Re: [firebird-support] Problem with where clause |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2018-01-05T12:43:16Z |
On 5-1-2018 13:37, Mark Rotteveel mark@...
[firebird-support] wrote:
V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND
'''||:TO_DATE||'''';
But that isn't the 'right' solution for this.
Mark
--
Mark Rotteveel
[firebird-support] wrote:
> Your immediate problems is caused by missing quotes around the dateSpecifically, it would need to be:
> values though.
V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND
'''||:TO_DATE||'''';
But that isn't the 'right' solution for this.
Mark
--
Mark Rotteveel