Subject | execute statement and in(variable) |
---|---|
Author | Olaf Kluge |
Post date | 2008-10-16T07:24:21Z |
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]
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]