search

IBM / nodejs-idb-connector

A JavaScript (Node.js) library for communicating with Db2 for IBM i, with support for queries, procedures, and much more. Uses traditional callback-style syntax
MIT License
38 stars 23 forks source link

Get Field Column Header text #116

Closed joaojmendes closed 4 years ago

joaojmendes commented 4 years ago

Please create a method to get column header of Field, at this moment we only have the:

statement.fieldName(index);

and maybe: statement.FieldHeader(index)

Thank you!

kadler commented 4 years ago

What do you mean by field header?

joaojmendes commented 4 years ago

The possibility to get the column header defined for a column (COLHDG, DDS KEYWORD) for use as column label in forms.

Thank you!

From: Kevin Adler notifications@github.com Reply to: IBM/nodejs-idb-connector reply@reply.github.com Date: Wednesday, 6 May 2020 at 04:52 To: IBM/nodejs-idb-connector nodejs-idb-connector@noreply.github.com Cc: João Mendes joao.j.mendes@outlook.com, Author author@noreply.github.com Subject: Re: [IBM/nodejs-idb-connector] Get Field Column Header text (#116)

What do you mean by field header?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/IBM/nodejs-idb-connector/issues/116#issuecomment-624428172, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AC7YHVKAVH2PZOMMMQE3GDTRQDNJBANCNFSM4MSKHAFA.

dmabupt commented 4 years ago

Hello @joaojmendes , Did you mean the label for a column? API link.

SQL_DESC_LABEL CHAR(128) The label for this column, if one exists. Otherwise, a zero-length string.For this attribute to be retrieved, the attribute SQL_ATTR_EXTENDED_COL_INFO must have been set to SQL_TRUE for either the statement handle or the connection handle.
joaojmendes commented 4 years ago

Hi,

Yeah, seems that is it. In syscolumns view the column is “COLUMN_HEADING”.

Thanks!

From: Xu Meng notifications@github.com Reply to: IBM/nodejs-idb-connector reply@reply.github.com Date: Friday, 15 May 2020 at 00:01 To: IBM/nodejs-idb-connector nodejs-idb-connector@noreply.github.com Cc: João Mendes joao.j.mendes@outlook.com, Mention mention@noreply.github.com Subject: Re: [IBM/nodejs-idb-connector] Get Field Column Header text (#116)

Hello @joaojmendeshttps://github.com/joaojmendes , Did you mean the label for a column? API linkhttps://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/cli/rzadpfncolattrs.htm. SQL_DESC_LABEL CHAR(128) The label for this column, if one exists. Otherwise, a zero-length string.For this attribute to be retrieved, the attribute SQL_ATTR_EXTENDED_COL_INFO must have been set to SQL_TRUE for either the statement handle or the connection handle.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/IBM/nodejs-idb-connector/issues/116#issuecomment-628930634, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AC7YHVLJHG5E2ARVYPFRKR3RRRZ6HANCNFSM4MSKHAFA.

dmabupt commented 4 years ago

Currently we have some problems when calling the API SQLColAttribute to get the column label. I need to find some other solutions.

github-actions[bot] commented 4 years ago

:wave: Hi! This issue has been marked stale due to inactivity. If no further activity occurs, it will automatically be closed.