for(MSXML::IXMLDOMNodePtr pLine = pDocRoot->firstChild; pLine != NULL; pLine = pLine->nextSibling)
{
log_id = GetSingleInt("SELECT GEN_ID(L_LOG_GEN,1) FROM rdb$database;");
mStatement.SetStatement((LPCTSTR)GetAttributes(pLine,log_id));
mStatement.ExecuteImmediate();
for(MSXML::IXMLDOMNodePtr pChild = pLine->firstChild; pChild != NULL; pChild = pChild->nextSibling)
{
list_id = GetSingleInt("SELECT GEN_ID(L_LIST_GEN,1) FROM rdb$database;");
stmt.Format("INSERT INTO l_list(l_list_id,l_log_id,l_name,l_value) VALUES (%d ,%d , \'%s\', \'%s\');",
list_id,log_id, GetNodeName(pChild),GetNodeText(pChild));
mStatement.SetStatement((LPCTSTR)stmt);
mStatement.ExecuteImmediate();
}
}// end for
|