Subject execute statement and in(variable)
Author Olaf Kluge
Hello,



i've two questions.



The follow code doesn't work:



Declare statement1 as string;



Statement1 = "select abc from tabc where x =" || :inputparameter || " into
:iabc "



For

Execute statement :statement1

Do begin

.

end



When I take the "for" into the statement-string, it doesn't work too.



The reason for this statement is an input parameter (string) with a list.
(100, 200, 300). This is also my second question:



The in(..) statement doesn't work, if I delivered an internal variable so
for example:



For select a from abc where b in (:inputparametervariable). But this works
fine: For select a from abc where b in (100, 200, 300).



Please, can you give me a tip? The question 1 is described in the
firebird-documentation, but it doesn't work. I don't like to set more
input-parameters for my procedure, therefore this stringlist.



Thanks in advance.







[Non-text portions of this message have been removed]