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:skopa...@elektlabs.cz http://www.elektlabs.cz On 25.1.2017 21:57, jorg...@yahoo.com [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. >