[GENERAL] Newbee to databases (ODBC)

2008-01-21 Thread Malm Paul
Hi all, I'm sorry to bother you with this question, I know it is a C++ ODBC question. But I'm a bit desperate. Perhaps I'll be lucky. I have a table with 2 columns no_char and blobdata were no_char is number of characters in blobdata. I would like to handle each row from the result set. I have

Re: [GENERAL] Newbee to databases (ODBC)

2008-01-21 Thread Andrei Kovalevski
Hello, You can use SQLGetData(...) function: //Setup selectstatement strcpy((char*) SQLStmt, Select no_char, blobdata from tab1); //Execute the statement rc = SQLExecDirect(dbConnection.StmtHandle, SQLStmt, SQL_NTS); //Define what to read out from the selection set rc =SQLBindCol(StmtHandle,