|Subject||Re: [firebird-support] change field depending variables|
> >> Pseudo code:If it works, it works :-)
> >> 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.Martijn Tonies
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!