/**
 * Checking SQLColumns
 *
 *
 *
 */

#include <windows.h>
#include <sql.h>
#include <sqlext.h>
#include <stdio.h>
#include <stdlib.h>

#define ODBC_CONNECT_DSN_NAME "Connect"
#define ODBC_CONNECT_DSN_NAME_LEN 7
#define ODBC_CONNECT_USER "yutaka"
#define ODBC_CONNECT_USER_LEN 6
#define ODBC_CONNECT_PWD ""
#define ODBC_CONNECT_PWD_LEN 0




int main(int ac,char **av) {
  HENV lpENV = NULL;
  HDBC lpDBC = NULL;
  HSTMT lpSTMT = NULL;
  SQLSMALLINT i=0;

  SQLAllocEnv(&lpENV);
  SQLAllocConnect(lpENV,&lpDBC);
  SQLConnect(lpDBC,
			    ODBC_CONNECT_DSN_NAME,
			    ODBC_CONNECT_DSN_NAME_LEN,
			    ODBC_CONNECT_USER,
			    ODBC_CONNECT_USER_LEN,
			    ODBC_CONNECT_PWD,
			    ODBC_CONNECT_PWD_LEN);
  SQLAllocStmt(lpDBC,&lpSTMT);
  //SQLExecDirect(lpSTMT,"drop table a;",SQL_NTS);

  SQLColumns(lpSTMT,
	    NULL,0,
	    NULL,0,
	    NULL,0,
	    NULL,0);
  SQLNumResultCols(lpSTMT,&i);
  printf("%d\n",i);
  SQLExecDirect(lpSTMT,"create temp table temp_a(a integer)",SQL_NTS);
  SQLExecDirect(lpSTMT,"select * from temp_a",SQL_NTS);
  for(i=SQL_SUCCESS;i!=SQL_NO_DATA;i=SQLFetch(lpSTMT));
  SQLCloseCursor(lpSTMT);
//  ASSERT_SUCCESS(SQLFreeStmt(lpSTMT,SQL_CLOSE),NULL);
//  SQLAllocStmt(lpDBC,&lpSTMT);
  SQLColumns(lpSTMT,
	    NULL,0,
	    NULL,0,
	    NULL,0,
	    NULL,0);
  SQLNumResultCols(lpSTMT,&i);
  printf("%d\n",i);
  SQLFreeStmt(lpSTMT,SQL_CLOSE);
  SQLDisconnect(lpDBC);
  SQLFreeConnect(lpDBC);
  SQLFreeEnv(lpENV);
  return 0;
 
}

