private void createSql() {
		String begindata = startdatetext.getText();
		String enddata = enddatetext.getText();
		if (begindata.isEmpty())
			begindata = "2000-01-01";
		if (enddata.isEmpty())
			enddata = "2099-12-31";

		int m = jcomchoose1;
		String observer = jcompid2[m];
		int m2 = jcomchoose2;
		String proposalid = jcomid2[m2];
		if ((!observer.equals("")) && (!proposalid.equals(""))) {
			allsql = "where startutc BETWEEN '" + begindata + "' AND '"
					+ enddata + "'" + "AND observer ='" + observer + "'"
					+ "AND proposalid ='" + proposalid + "'";

		} else {
			if ((!observer.equals("")) && (proposalid.equals(""))) {
				allsql = "where startutc BETWEEN '" + begindata + "' AND '"
						+ enddata + "'" + "AND observer ='" + observer + "'";

			} else {
				if ((observer.equals("")) && (!proposalid.equals(""))) {
					allsql = "where startutc BETWEEN '" + begindata + "' AND '"
							+ enddata + "'" + "AND proposalid ='" + proposalid
							+ "'";
				} else {
					allsql = "where startutc BETWEEN '" + begindata + "' AND '"
							+ enddata + "'";
				}
			}
		}
	}