From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org> |
Subject: | What is the problem with this code? |
Date: | 2018-10-19 04:49:12 |
Message-ID: | CA+FnnTyfwr3Q+=AWAN--w8DyQxEuyFkjtBoWxakDtMN=5kCS1A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
Hi, ALL,
[code]
std::wstring query1 = L"SHOW log_directory";
std::wstring query2 = L"SHOW log_filename";
SQLWCHAR *qry1 = new SQLWCHAR[query1.length() + 2];
SQLWCHAR *qry2 = new SQLWCHAR[query2.length() + 2];
memset( qry1, '\0', query1.length() + 2 );
memset( qry2, '\0', query2.length() + 2 );
uc_to_str_cpy( qry1, query1 );
uc_to_str_cpy( qry2, query2 );
RETCODE ret = SQLAllocHandle( SQL_HANDLE_STMT, m_hdbc, &m_hstmt );
if( ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO )
{
ret = SQLPrepare( m_hstmt, qry1, SQL_NTS );
if( ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO )
{
GetErrorMessage( errorMsg, 1 );
result = 1;
}
else
{
ret = SQLDescribeCol( m_hstmt, 1, columnName, 256,
&columnNameLen, &columnDataType, &columnDataSize, &columnDataDigits,
&columnDataNullable );
if( ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO )
{
GetErrorMessage( errorMsg, 1 );
result = 1;
}
[/code]
The SQLDescribeCol() call fails with the error invalid column number".
Does anybody have any idea?
Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Clemens Ladisch | 2018-10-19 07:04:31 | Re: What is the problem with this code? |
Previous Message | Tom Lane | 2018-10-18 22:58:13 | Re: convert real to numeric. |
From | Date | Subject | |
---|---|---|---|
Next Message | Clemens Ladisch | 2018-10-19 07:04:31 | Re: What is the problem with this code? |
Previous Message | 2018-10-09 15:09:54 | TR: Request for quotation and partnership for ODBC Driver |