关于c++中ISqliteDatabase数据库操作问题
这个方法是根据姓名进行排序的,可是总是执行失败输出"execute sequence operate by param error\r\n"这句话
同样的方法我把sql语句换成删除的语句,执行成功的。这是哪里有错误?
//按字段名排序
bool CMatDBInterface::SequenceMat2DB(LPCTSTR strfileName)
{
if (m_pIDataBaseParam == NULL)
{
printf("ISqliteDataBase is NULL\r\n");
return false;
}
//char buff[200] = { 0 };
//sprintf(buff, "select * from TABLE_MAT_ITEM order by (\"%s\") ", strfileName);
//string strsql = (string)buff;
string strsql = "select * from TABLE_MAT_ITEM order by grade desc";
cout << strsql<<endl;
DataBaseParam *pDataBaseParam = m_pIDataBaseParam->CreateParam(strsql.c_str());
if (pDataBaseParam == NULL)
{
printf("create database param error\r\n");
return false;
}
if (m_pISqliteDataBase->ExecCmdByParam(pDataBaseParam) == false)
{
printf("execute sequence operate by param error\r\n");
return false;
}
printf("execute sequence operate by param success\r\n");
return true;
}