Hi, the following select fetches all records of the table (FB 2.5.4) and obviously brings no resultset.
select * from Mytable where 1=0 Is there a trick to force Firebird not to scan all records? We sometimes use such a statement (in for select loops) to get different datasets and process it in the loop. select ... from Table1 where :InputParam = 'A' union select ... from Table2 where :InputParam = 'B' Regards, Josef
