Click here to Skip to main content
15,881,852 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I'm developing an android app and it works in android 4.x version perfectly but in android 2.2 it stops working and does nothing without any error. From the debug I found that this problem is because of a join sql statement and when it comes to while statement it stops with no error.
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);
                }


It should return about 600 rows from my sqlite db.
I tested table view,thread,async and ... but I didn't find any solution.
I do appreciate for any help
Posted
Updated 30-Sep-15 6:25am
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900