Subject | If and For Select |
---|---|
Author | paultugwell |
Post date | 2008-02-12T14:27:48Z |
Basically i want to do this in a stored procedure
if (X=0) then
for select a from b into :c
else
for select a from b where z = :x into c
do
begin
process all the returned results in the same way irrespective of which
select for statement was used.
suspend;
end;
Is this possible?
If so, how would I code the for select statements?
Using FB 1.5
if (X=0) then
for select a from b into :c
else
for select a from b where z = :x into c
do
begin
process all the returned results in the same way irrespective of which
select for statement was used.
suspend;
end;
Is this possible?
If so, how would I code the for select statements?
Using FB 1.5