bind binary data

elliotllb — Tue, 13 Jan 2009 15:34:00 GMT

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

try

{

CppSQLite3DB db;

db.open(szDBFile);

db.execDML(CREATE_TABLE_NOTES);

int nFileLen = 0;

BYTE* pData = llySqlite_FileToBlob(lpszFileRtf,nFileLen);

CppSQLite3Statement stmt ;

stmt = db.compileStatement("insert into tNotes values(NULL,'TEST','test',?);");

//stmt.bind(3, bin, sizeof bin);

stmt.bind(1, pData, nFileLen); // begin from ? ‘s index.Here ? is in the first.So 1

stmt.execDML();

if ( pData )

delete []pData;

pData = NULL;

}

catch (CppSQLite3Exception& e)

{

//cerr << e.errorCode() << ":" << e.errorMessage() << endl;

}

Great Windows Tool : sqlite3