希望存的是上万的byte数组,但是存进去的只有一小部分。直接上代码和图:
CString tmp;
tmp.Format("insert into DigiSprInfo( samplecount,"\
"lat,long,heigh,radarheigh,ggcount,ggtime,sprttotalnum,"\
"sprttype,data) values(%d,%f,%f,%f,%f,%d,%d,%d,%d,?);",
DataInfo_all->SampleCount,
DataInfo_all->Long,
DataInfo_all->Lat,
DataInfo_all->Height,
DataInfo_all->Radaheight,
DataInfo_all->GGCount,
DataInfo_all->GGTime,
DataInfo_all->SprtTotalNum,
DataInfo_all->SprtType,
DataInfo_all->DataSpr);
//插入数据
sqlite3_prepare(m_pGlobalDB,tmp,-1,&stmt,&pzTail); //准备执行语句,实际并不执行
sqlite3_bind_blob(stmt,1,DataInfo_all->DataSpr,DataInfo_all->datalen-108,NULL); //附加值
//sqlite3_bind_blob(stmt,1,DataInfo_all->DataSpr,DataInfo_all->datalen-108,NULL); //附加值
int JG = sqlite3_step(stmt); //执行prepare语句
if ( JG !=SQLITE_DONE )
{
JG = 111;
}
sqlite3_finalize(stmt); //释放对象
sqlite3_close(m_pGlobalDB);
执行的结果:是只有几个数据