Subject | Re: [firebird-support] Change Field on the fly |
---|---|
Author | Ivan Prenosil |
Post date | 2006-12-20T11:12:10Z |
> Do in pseudo code:select case when :Question = 'Y' then Field1 else Field1 end from TableA ...
>
> 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..
Ivan