Subject Re: [firebird-support] Change Field on the fly
Author Ivan Prenosil
> Do in pseudo code:
>
> declare AField varchar( 20 );
>
> if ( :Question = 'Y' ) then AField='Field1';
> if ( :Question = 'N' ) then AField='Field2';
>
> select :AField from TableA where SomeField='Z' into ecc.ecc..

select case when :Question = 'Y' then Field1 else Field1 end from TableA ...

Ivan