Subject | Re: [firebird-support] Re: How to get a list of columns from another select |
---|---|
Author | Slavomir Skopalik |
Post date | 2017-01-25T22:08:18Z |
Hi,
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.
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-----------------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---------------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopalik@...
http://www.elektlabs.cz
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.
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-----------------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---------------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopalik@...
http://www.elektlabs.cz
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.
>