Subject Re: [firebird-support] Re: How to get a list of columns from another select
Author Slavomir Skopalik

Dimitri is right.

If you just prepare statement (ANYONE) server will return record
structure including names and data types.

Also, you task is not problem to solve without prepare.

Just at first iteration read the names and put to output before data.


Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
Mobile: +420 724 207 851
icq:199 118 333

On 25.1.2017 21:57, jorgebj@... [firebird-support] wrote:
> Hi Dimitry.
> Is not that. The subquery is entered at runtime in my application and then exported to a spreadsheet.
> In my application there is a screen where the user can enter the query (ANY), it is exported and they only see the results but do not know the name of the column.
> When exporting the query, I must get the names of the columns and also send them along with the data.