SVN Commit by dpage: r4232 - trunk/pgadmin3/src/agent

Author: dpage
Date: 2005-05-23 09:43:57 +0100 (Mon, 23 May 2005)
New Revision: 4232

Modified:
   trunk/pgadmin3/src/agent/pgaJob.cpp
   trunk/pgadmin3/src/agent/pgaStep.cpp
Log:
Limit the number of log rows displayed for jobs/steps to settings->MaxRows()

Modified: trunk/pgadmin3/src/agent/pgaJob.cpp
===================================================================
--- trunk/pgadmin3/src/agent/pgaJob.cpp    2005-05-23 08:31:10 UTC (rev 4231)
+++ trunk/pgadmin3/src/agent/pgaJob.cpp    2005-05-23 08:43:57 UTC (rev 4232)
@@ -22,6 +22,7 @@
 #include "pgaStep.h"
 #include "pgaSchedule.h"

+extern sysSettings *settings;

 pgaJob::pgaJob(const wxString& newName)
 : pgDatabaseObject(PGA_JOB, newName)
@@ -170,7 +171,8 @@
              wxT(", (jlgstart + jlgduration) AS endtime")
              wxT("  FROM pgagent.pga_joblog\n")
              wxT(" WHERE jlgjobid = ") + NumToStr(GetRecId()) +
-             wxT(" ORDER BY jlgstart DESC");
+             wxT(" ORDER BY jlgstart DESC") +
+             wxT(" LIMIT ") + NumToStr(settings->GetMaxRows());

     if (statistics)
     {

Modified: trunk/pgadmin3/src/agent/pgaStep.cpp
===================================================================
--- trunk/pgadmin3/src/agent/pgaStep.cpp    2005-05-23 08:31:10 UTC (rev 4231)
+++ trunk/pgadmin3/src/agent/pgaStep.cpp    2005-05-23 08:43:57 UTC (rev 4232)
@@ -22,6 +22,7 @@
 #include "pgaStep.h"
 #include "pgaSchedule.h"

+extern sysSettings *settings;

 pgaStep::pgaStep(pgCollection *_collection, const wxString& newName)
 : pgaJobObject(_collection->GetJob(), PGA_STEP, newName)
@@ -155,7 +156,8 @@
              wxT(", (jslstart + jslduration) AS endtime")
              wxT("  FROM pgagent.pga_jobsteplog\n")
              wxT(" WHERE jsljstid = ") + NumToStr(GetRecId()) +
-             wxT(" ORDER BY jslstart DESC");
+             wxT(" ORDER BY jslstart DESC")
+             wxT(" LIMIT ") + NumToStr(settings->GetMaxRows());

     if (statistics)
     {