Index: src/libchcore/TSQLiteSerializerRowReader.cpp =================================================================== diff -u -N -r1875711000138ff9d4185c2e3e74d455533de8a8 -r73583f2ca01fa1b2eae49bbc63bce46b9ecff5db --- src/libchcore/TSQLiteSerializerRowReader.cpp (.../TSQLiteSerializerRowReader.cpp) (revision 1875711000138ff9d4185c2e3e74d455533de8a8) +++ src/libchcore/TSQLiteSerializerRowReader.cpp (.../TSQLiteSerializerRowReader.cpp) (revision 73583f2ca01fa1b2eae49bbc63bce46b9ecff5db) @@ -23,6 +23,7 @@ #include "ErrorCodes.h" #include #include "TSQLiteStatement.h" +#include BEGIN_CHCORE_NAMESPACE @@ -49,8 +50,9 @@ { // generate query to retrieve data from db TString strQuery; - strQuery = boost::str(boost::wformat(L"SELECT %1% FROM %2%") % (PCTSTR)m_spColumns->GetCommaSeparatedColumns() % (PCTSTR)m_strContainerName).c_str(); + strQuery = boost::str(boost::wformat(L"SELECT %1% FROM %2% ORDER BY id") % (PCTSTR)m_spColumns->GetCommaSeparatedColumns() % (PCTSTR)m_strContainerName).c_str(); + ATLTRACE(_T("Executing query: %s\n"), (PCTSTR)strQuery); m_spStatement->Prepare(strQuery); m_bInitialized = true; }