On 11-1-2017 10:35, startx252000@... [firebird-support] wrote:

>
>
> i mean taht i have no result (it's empty) and i am sure my string existe
> in one table

That is probably because you are using

' WHERE '||:DANSCOLONNE||' = ?'

instead of

' WHERE '||:DANSCOLONNE||' = ''%'' || ? || ''%'''

or

' WHERE '||:DANSCOLONNE||' CONTAINING ?'

You might also want to account for case sensitivity, etc.

Also `EXECUTE STATEMENT (STMT) (CHAINE) INTO :RESULT;` won't work
properly if there is more than one row, you might want to switch to
using `for execute statement` (see
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-psql-coding.html#fblangref25-psql-forexec)

Mark
--
Mark Rotteveel