selectedHospitalId = 3; cursor = G.dbHelper.myDataBase.rawQuery("Select Distinct HospitalDosageForm.DrugID," + "DrugsName.DrugName, HospitalDosageForm.IRC from HospitalDosageForm Join DrugsName On" + " HospitalDosageForm.DrugID = DrugsName.DrugID Where DrugsName.DrugNameType = 'A' " + "and HospitalDosageForm.DosageFormID = -1 and HospitalDosageForm.HospitalID = " + selectedHospitalId + " order by DrugsName.DrugName", null); G.drugs.clear(); while (cursor.moveToNext()) { drug = new Drug() {}; drug.DrugID = cursor.getInt(cursor.getColumnIndex("DrugID")); drug.DrugName = cursor.getString(cursor.getColumnIndex("DrugName")); drug.BrandID = cursor.getInt(cursor.getColumnIndex("IRC")); drug.HospitalID = selectedHospitalId; G.drugs.add(drug); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)