retrieving data from database

See more:

SQL

ODBC

VisualC++

Hi all,


I am fetching 1000 records at a time using SQLFetchScroll (). I got id array 1000 records but name structure i am getting garbage values. how to get both array and structure values at a time.

int id[1000];
  
struct { SQLINTEGER  len; unsigned char arr[82]; } name[1000];

SQLINTEGER id_ind = 0;

SQLUINTEGER	NumRowsFetched;

SQLSetStmtAttr(hStmtSelect, SQL_ATTR_ROW_BIND_TYPE, (void*) (sizeof(name) / 1000), 0);
SQLSetStmtAttr(hStmtSelect, SQL_ATTR_ROW_ARRAY_SIZE, (void *)1000, 0);
SQLSetStmtAttr(hStmtSelect, SQL_ATTR_ROW_STATUS_PTR, RowStatusArray, 0);
SQLSetStmtAttr(hStmtSelect, SQL_ATTR_ROWS_FETCHED_PTR, &NumRowsFetched, 0);


rc = SQLBindCol(hStmtSelect, 1, SQL_INTEGER, (SQLPOINTER) &id, sizeof (id), &id_ind);
rc = SQLBindCol(hStmtSelect, 2, SQL_C_CHAR, &name->arr,  sizeof (name), name->len);


rc = SQLExecDirect(hStmtSelect, SQLStmt, SQL_NTS);

rc = SQLFetchScroll(hStmtSelect,SQL_FETCH_NEXT,0);

please give me the suggesions.



Thank in advance,
Latha.