Martijn Tonies wrote:

> Hi,
>
>> Pseudo code:
>>
>> declare field varchar( 20 );
>>
>> if ( :question = 'y' ) then field='Field1';
>> if ( :question = 'n' ) then field='Field2';
>>
>> select :field from Table_a where Field2 = '1' into :answer.
>>
>> Please can anyone tell me how to do this???
>
> Take a look at EXECUTE STATEMENT in the Firebird
> 1.5 release notes.

why not something like

SELECT CASE
WHEN :QUESTION = 'Y' THEN Field1
WHEN :QUESTION = 'N' THEN Field2
ELSE NULL
END as MyField
from Table_a where Field2 = '1' into :answer

I just thought EXECUTE STATEMENT ought to be avoided when possible.

HTH,
Set