Hello SET,
thank you! >>Hello, >> >>is the following scenario possible (without a statement)? >> >>If inputvariable A is null then >>For select b, c, d from table a >>Else >>For select b, c, d from table b (same fields like table a but different >>informations (data)) >> >>Begin >> >>End >> >>The Block begin-and have the same code. I don't need a begin-end-block >>for both conditions (if. then for select . begin-end else for select . >>begin-end) > >I think this is quite simple, Olaf, just use a CTE: > >[for] with tmp(b, c, d) >as >(select b, c, d from table_a > where cast(:ivA as char(1)) is null > union > select b, c, d from table_b > where cast(:ivA as char(1)) is not null) > >[for] select b, c, d from tmp do >begin >... >end > >The one thing I do not know (and haven't tested), is where to put FOR. Hence, I put it within >brackets before WITH and SELECT. One of these you have to delete, the other just remove the brackets. Sorry, no need to complicate things with a CTE. The following at least works with EXECUTE BLOCK: execute block (iv1 char(1) = ?) returns (b varchar(32), c varchar(32), d varchar(32)) as begin for select b, c, d from table_a where :iv1 is null union select b, c, d from table_b where :iv1 is not null into :b, :c, :d do begin suspend; end end HTH, Set [Non-text portions of this message have been removed]
