Subject Re: [IBO] Re: Building a statement at runtime
Author Dmitry Beloshistov
Hello, paolopf!
You wrote to <IBObjects@yahoogroups.com> on Tue, 18 Jun 2002 10:52:30 -0000:

p> I try to explain better.
p> I've created, in the sql explorer, a new procedure:
p> CREATE PROCEDURE PROCEDURE1 AS declare variable C0 varchar(100);
p> declare variable C1 varchar(100);
p> declare variable C2 varchar(100);
p> declare variable C3 varchar(100);
p> declare variable C4 varchar(100);
p> BEGIN
p> C1 = 'INSERT INTO PIANIF(MINUTI, ';
p> C2 = 'CLV2) ';
p> C3 = 'VALUES(1, ';
p> C4 = '"00003")';
p> C0 = C1+C2+C3+C4;
p> C0;
p> END

1) IB/FB not support execute statement what builded in runtime.
2) String concatenation will be
Str1 || Str2 || Str3
but no
Str1+Str2+Str3

WBR, Dmitry Beloshistov AKA [-=BDS=-]
e-mail: torin@...