[BugFix] fix sql error

cashlalala · Nov 23, 2014 · 7a38cf1 · 7a38cf1
1 parent 9d041d8
commit 7a38cf1
Showing 1 changed file with 2 additions and 1 deletion.
diff --git a/src/casemgmt/Tab_WoundAssessment.java b/src/casemgmt/Tab_WoundAssessment.java
@@ -224,12 +224,13 @@ private void refreshData() {
 
 			rs = DBC.executeQuery(sql);
 			if (!rs.next()) {
-				String sqlInsert = "INSERT into wound_accessment '"+  guid +  "', " 
+				String sqlInsert = "INSERT into wound_accessment values ( '"+  guid +  "', " 
 				+ " '" + this.caseGuid + "', '" + p_no + "'";
 				int i = 0;
 				for (i = 0; i < 16; i++) {
 					sqlInsert = sqlInsert + ", NULL";
 				}
+				sqlInsert += ")";
 				DBC.executeUpdate(sqlInsert);
 			} else {
 				if (rs.getString("wound_accessment.Hypertension") != null