--- MicrosoftDBLayer.cpp	2006/09/12 09:09:30	54
+++ MicrosoftDBLayer.cpp	2006/09/12 10:16:06	56
@@ -210,7 +210,7 @@
 Equipment MicrosoftDBLayer::GetEquipment(CString wantBarcode)
 {
 
-	CString barcode,name,description,placement,status;
+	CString barcode,name,description,placement,status,statusid;
 
 	CString SQL;
 
@@ -218,7 +218,7 @@
 
 	Equipment e;
 
-	SQL.Format("SELECT Stregkode,Navn,Udstyr.Beskrivelse,Placering,Status.Beskrivelse FROM Udstyr INNER JOIN Status ON Udstyr.Status = Status.StatusID Where (Stregkode = '%s')", wantBarcode);
+	SQL.Format("SELECT Stregkode,Navn,Udstyr.Beskrivelse,Placering,Status.Beskrivelse, Udstyr.Status FROM Udstyr INNER JOIN Status ON Udstyr.Status = Status.StatusID Where (Stregkode = '%s')", wantBarcode);
 	CRecordset rs(&db);
 	rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
 	if (!rs.IsEOF() )
@@ -228,12 +228,14 @@
 		rs.GetFieldValue(2,description);
 		rs.GetFieldValue(3,placement);
 		rs.GetFieldValue(4,status);
+		rs.GetFieldValue(5,statusid);
 
 		e.barcode = barcode;
 		e.name = name;
 		e.description = description;
 		e.placement = placement;
 		e.status = status;
+		e.statusid = atoi( statusid );
 
 		rs.Close();