--- DatabaseLayer.cpp	2006/08/31 16:32:37	17
+++ DatabaseLayer.cpp	2006/09/01 02:23:19	19
@@ -1,3 +1,5 @@
+
+
 #include "StdAfx.h"
 #include ".\databaselayer.h"
 
@@ -277,10 +279,10 @@
 	for (int i=0; i<buffer.size(); i++) { 
 		//fill Equipment::checkouts
 		
-		SQL = "SELECT Udlån.StartDato, Udlån.Afleveringsdato,Udlån.Antaldage, Person.Initialer\
+		SQL = "SELECT TOP 10 Udlån.StartDato, Udlån.Afleveringsdato,Udlån.Antaldage, Person.Initialer\
 				FROM Udlån\
 				INNER JOIN Person ON Udlån.PersonID = Person.PersonID ";
-		SQL += "WHERE Udlån.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC";
+		SQL += "WHERE Udlån.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO DESC";
 		CRecordset rs(&db);
 		rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
 		if (rs.GetRecordCount()>0) {