On 5-1-2018 12:52, [email protected] [firebird-support] wrote: > I am using FB 3 and IBExpert and with the DDL below I get message > <Invalid token dynamic SQL error SQL error code= -104 unexpected end of > command> and it works when I remove the where clause. I think the > problem is with the between command. Can you please help me ?
Why are you using `execute statement`, and not simply `for select ...`? There doesn't seem to be any reason why you need dynamically built SQL here, as the only dynamic thing are the from_date and to_date parameters, which would work just fine in `for select ...`. So, first try to convert this to a normal `for select` statement. Otherwise, if you really need dynamically generated SQL, change the last line to: V1=:V1 || ' WHERE CF.DATE_COMMANDE BETWEEN :FROM_DATE AND :TO_DATE'; and use `execute statement v1 (from_date := from_date, to_date := to_date) into ...` Your immediate problems is caused by missing quotes around the date values though. Mark -- Mark Rotteveel
