in

AisNote Software

The software can improve your computer work

Great Windows Tool

bind binary data

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;

    }

Published Jan 13 2009, 04:34 PM by elliotllb
Filed under:

Comments

 

aisnote said:

当call sqlite3 去bind 一个 blob的时候,有几个blob,从1的基数开始。比如:insert into table values(?,?)

有2 个?,则bind(1)就是bind 第一个?,以此类推。

January 13, 2009 5:47 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
aisnote software
Powered by Community Server (Non-Commercial Edition), by Telligent Systems