public void setjobDetail() { Cursor cursor = DatabaseView.query( "SELECT * FROM ServiceJob, Purchase, Product, Company WHERE jobNo ='" + selectedjobNo + "'" + " AND Purchase.prodNo = Product.prodNo AND Purchase.comNo = Company.comNo AND Purchase.serialNo = ServiceJob.serialNo"); cursor.moveToFirst(); String _jobProblem = cursor.getString(cursor.getColumnIndex("jobProblem")); String _jobSerialNo = cursor.getString(cursor.getColumnIndex("serialNo")); String _jobRequestDate = cursor.getString(cursor.getColumnIndex("requestDate")); String _jobVisitDate = cursor.getString(cursor.getColumnIndex("visitDate")); String _jobStartTime = cursor.getString(cursor.getColumnIndex("jobStartTime")); String _jobEndTime = cursor.getString(cursor.getColumnIndex("jobEndTime")); String _jobRemark = cursor.getString(cursor.getColumnIndex("remark")); companyID = cursor.getString(cursor.getColumnIndex("comNo")); prodctID = cursor.getString(cursor.getColumnIndex("prodNo")); jobNo.setText(selectedjobNo); jobProblem.setText(_jobProblem); jobSerialNo.setText(_jobSerialNo); jobRequestDate.setText(_jobRequestDate); jobVisitDate.setText(_jobVisitDate); jobStartTime.setText(_jobStartTime); jobEndTime.setText(_jobEndTime); jobRemark.setText(_jobRemark); jobCompany.setText(cursor.getString(cursor.getColumnIndex("comName"))); jobCompany.setOnClickListener(this); productName.setText(cursor.getString(cursor.getColumnIndex("prodName"))); productName.setOnClickListener(this); for (int i = 0; i < jobStatusItem.length; i++) if (jobStatusItem[i].equalsIgnoreCase(cursor.getString(cursor.getColumnIndex("jobStatus")))) jobStatus.setSelection(i); }