1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101
|
/**
Copyright (C) 1995, 1996 by Ke Jin <kejin@visigenic.com>
Enhanced for unixODBC (1999) by Peter Harvey <pharvey@codebydesign.com>
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
**/
#include <config.h>
#include "driver.h"
RETCODE SQL_API SQLDescribeCol(
HSTMT hstmt,
UWORD icol,
UCHAR* szColName,
SWORD cbColNameMax,
SWORD* pcbColName,
SWORD* pfSqlType,
UDWORD* pcbColDef,
SWORD* pibScale,
SWORD* pfNullable )
{
stmt_t* pstmt = hstmt;
char* colname;
int colnamelen, sqltype, precision, ncol;
RETCODE retcode = SQL_SUCCESS;
UNSET_ERROR( pstmt->herr );
ncol = nnsql_getcolnum(pstmt->yystmt);
if ( icol > (UWORD)(ncol - 1) )
{
PUSHSQLERR( pstmt->herr, en_S1002 );
return SQL_ERROR;
}
colname = nnsql_getcolnamebyidx(
nnsql_column_descid(pstmt->yystmt, icol) );
colnamelen = STRLEN(colname);
if ( szColName )
{
if ( cbColNameMax < colnamelen + 1 )
{
colnamelen = cbColNameMax - 1;
PUSHSQLERR( pstmt->herr, en_01004 );
retcode = SQL_SUCCESS_WITH_INFO;
}
STRNCPY( szColName, colname, colnamelen);
szColName[colnamelen] = 0;
if ( pcbColName )
*pcbColName = colnamelen;
}
if ( nnsql_isstrcol(pstmt->yystmt, icol) )
{
sqltype = SQL_LONGVARCHAR;
precision = SQL_NO_TOTAL;
}
else if ( nnsql_isnumcol(pstmt->yystmt, icol) )
{
sqltype = SQL_INTEGER;
precision = 10;
}
else if ( nnsql_isdatecol(pstmt->yystmt, icol) )
{
sqltype = SQL_DATE;
precision = 10;
}
else
{
sqltype= 0;
precision = SQL_NO_TOTAL;
}
if ( pfSqlType )
*pfSqlType = sqltype;
if ( pcbColDef )
*pcbColDef = precision;
if ( pfNullable )
*pfNullable = nnsql_isnullablecol(pstmt->yystmt, icol);
return retcode;
}
|