Subject Re: [firebird-support] Variable column in SELECT.
Author Radu Sky
Soporte Solutec wrote:
> I get the idea but i have an error trying to execute mystr: parsing error - mystr. (I think is telling to me it does not recognize mystr like something that can be execute).
> Remember I am trying to do that into a store procedure. Let me know.


campo = 'telefono';
EXECUTE STATEMENT 'select ' || :campo || ' from tabla' into :valor;

Note that 'select ' || :campo || ' from tabla' must be singleton