Click here to Skip to main content
15,909,051 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
QuestionHow should I hide or remove tabs in a property sheet without getting the PC crashed? Pin
Joan M5-Mar-01 4:58
professionalJoan M5-Mar-01 4:58 
QuestionHow do I write a file to an edit ctrl or to other ctrl? Pin
5-Mar-01 4:09
suss5-Mar-01 4:09 
AnswerRe: How do I write a file to an edit ctrl or to other ctrl? Pin
l a u r e n5-Mar-01 4:35
l a u r e n5-Mar-01 4:35 
GeneralRe: How do I write a file to an edit ctrl or to other ctrl? Pin
Chris Losinger5-Mar-01 4:55
professionalChris Losinger5-Mar-01 4:55 
GeneralRe: How do I write a file to an edit ctrl or to other ctrl? Pin
l a u r e n5-Mar-01 10:09
l a u r e n5-Mar-01 10:09 
GeneralBulk operations with Long binary. HELP Pin
Alex Barzovski5-Mar-01 3:57
Alex Barzovski5-Mar-01 3:57 
GeneralRe: Bulk operations with Long binary. HELP Pin
l a u r e n5-Mar-01 4:33
l a u r e n5-Mar-01 4:33 
GeneralRe: Bulk operations with Long binary. HELP Pin
Alex Barzovski5-Mar-01 13:16
Alex Barzovski5-Mar-01 13:16 
Thanks,
I've already found out. If you are interested, here is the snippet


SQLHSTMT hStmt; // Statement handle.
SQLHDBC hDbc; // Connection Handle.
SQLHENV hEnv; // Environment Handle.

UINT s = MAX_JOBDESC_SIZE * R_SIZE;
BYTE * Storage = new BYTE[ s ];

SQLINTEGER * WordRecordID = new SQLINTEGER[R_SIZE]; // Job ID Field Buffer
SQLINTEGER * WordRecordIDLength = new SQLINTEGER[R_SIZE]; // jobID Length Array

SQLINTEGER * FileIndex = new SQLINTEGER[R_SIZE];
SQLINTEGER * FileIndexLength = new SQLINTEGER[R_SIZE];


SQLINTEGER * WordDescLength = new SQLINTEGER[R_SIZE];
SQLRETURN rc; // Return code
SQLINTEGER value, i;

// BLA- BLA -BLA: Connect, cursor options etc
// One of them is SQL_ROWSET size:

rc = SQLSetStmtOption(hStmt,SQL_ROWSET_SIZE,R_SIZE);
CheckError(hStm);
//Then
rc = SQLExecDirect(hStmt,(SQLCHAR*)"SELECT * FROM WORDS",SQL_NTS);
CheckError(hStmt);

rc = SQLBindCol(hStmt,1,SQL_C_SLONG,WordRecordID,sizeof(LONG),WordRecordIDLength);
CheckError(hStmt);

rc = SQLBindCol(hStmt,2,SQL_C_SLONG,FileIndex,sizeof(LONG),FileIndexLength);
CheckError(hStmt);

rc = SQLBindCol(hStmt,3,SQL_C_BINARY,Storage,MAX_JOBDESC_SIZE,WordDescLength);
CheckError(hStmt);


LONG Size = 0 ;
if (SQLFetch(hStmt)!= SQL_NO_DATA)
// Set Position API.
{
/*Put data ( copy ) into Storage,FileIndex,WordRecordID and their length arrays. Then: */

rc = SQLSetPos(hStmt,0,SQL_ADD,SQL_LOCK_NO_CHANGE);
CheckError(hStmt);

}

/* Clean up, disconnect*/

Thanks again.

Alex Barzovski

GeneralRe: Bulk operations with Long binary. HELP Pin
Alex Barzovski5-Mar-01 13:17
Alex Barzovski5-Mar-01 13:17 
GeneralWindows Driver Development Pin
.::RockNix::.5-Mar-01 0:03
.::RockNix::.5-Mar-01 0:03 
GeneralRe: Windows Driver Development Pin
l a u r e n5-Mar-01 2:41
l a u r e n5-Mar-01 2:41 
GeneralRe: Windows Driver Development Pin
MickAB5-Mar-01 3:12
MickAB5-Mar-01 3:12 
GeneralRe: Windows Driver Development Pin
.::RockNix::.5-Mar-01 4:37
.::RockNix::.5-Mar-01 4:37 
GeneralRe: Windows Driver Development Pin
MickAB5-Mar-01 5:57
MickAB5-Mar-01 5:57 
GeneralRe: Windows Driver Development Pin
.::RockNix::.5-Mar-01 21:29
.::RockNix::.5-Mar-01 21:29 
GeneralRe: Windows Driver Development Pin
MickAB6-Mar-01 1:17
MickAB6-Mar-01 1:17 
GeneralRe: Windows Driver Development Pin
.::RockNix::.6-Mar-01 4:31
.::RockNix::.6-Mar-01 4:31 
GeneralRe: Windows Driver Development Pin
MickAB6-Mar-01 5:50
MickAB6-Mar-01 5:50 
GeneralRe: Windows Driver Development Pin
.::RockNix::.6-Mar-01 21:35
.::RockNix::.6-Mar-01 21:35 
GeneralRe: Windows Driver Development Pin
MickAB6-Mar-01 23:42
MickAB6-Mar-01 23:42 
GeneralRe: Windows Driver Development Pin
Joe Moldovan5-Mar-01 7:10
Joe Moldovan5-Mar-01 7:10 
GeneralRe: Windows Driver Development Pin
MickAB5-Mar-01 3:12
MickAB5-Mar-01 3:12 
GeneralHelp needed with PropertySheet Pin
4-Mar-01 23:36
suss4-Mar-01 23:36 
GeneralSetProcessWorkingSetSize and Memory Locking Pin
4-Mar-01 20:07
suss4-Mar-01 20:07 
GeneralRe: SetProcessWorkingSetSize and Memory Locking Pin
4-Mar-01 22:56
suss4-Mar-01 22:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.