2,209
社区成员
发帖
与我相关
我的任务
分享
ELESQLiteFWTable *SQLFWTable = new ELESQLiteFWTable(DBName); //封装了一下sqlite3
AnsiString SQL = AnsiString().sprintf("SELECT * FROM %s "
" WHERE ParentID = %d and Deleted <> %d "
" ORDER BY SortID",
G_TABLENAME,iParentID,NTDF_DELETED);
if(SQLFWTable->IsOpened && SQLFWTable->ExecSelect(SQL))
{
do
{
iTid = SQLFWTable->FieldByNameAsInteger("TID");
m_TreeValueList->Add(NodeTitle);
MakeChTreeEx(DBName,iTid,iTreeLevel+1); //递归调用。
}while(SQLFWTable->Next());//这个NEXT函数就是调用sqlite3_step来取下一条数据。
}
SQLFWTable->CloseDB();
delete SQLFWTable;
SQLFWTable = NULL;