Subject | Re: [firebird-support] Variable column in SELECT. |
---|---|
Author | Radu Sky |
Post date | 2006-06-24T23:17:21Z |
Soporte Solutec wrote:
campo = 'telefono';
EXECUTE STATEMENT 'select ' || :campo || ' from tabla' into :valor;
Note that 'select ' || :campo || ' from tabla' must be singleton
HTH
Radu
> 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).Hello,
>
> 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
HTH
Radu