check Your database that it has data what u have entered.if it has entered
value than check the value of cursor which are coming from query for
fetching the value from database.

On Tue, Mar 6, 2012 at 10:49 AM, Jagruti Sangani <
jagruti.sang...@inextrix.com> wrote:

> hello below is my code of database that fetch value from database and fill
> in listview. when we click on tab then screen will crash the application.
>
>
>  path = "/data/data/"
>                    + mContext.getApplicationContext().getPackageName()
>                      + "/databases/" + "call_history.db";
>          db= ((Activity)
> mContext).openOrCreateDatabase(path,SQLiteDatabase.CREATE_IF_NECESSARY,null);
>          db.setVersion(1);
>          db.setLocale(Locale.getDefault());
>          db.setLockingEnabled(true);
>
> cur=db.query("history", null,"call_type='r'",null, null, null,null);
> //Cursor cur = db.query("history",null, null, null, null, null, null);
> cur.moveToFirst();
> while (cur.isAfterLast() == false) {
>        hm = new HashMap<String, Object>();
>        hm.put(CONTACTKEY, cur.getString(1));
>        hm.put(DURATION,"call duration:"+ cur.getString(2));
>        hm.put(STIME,"call start time:"+cur.getString(3));
>       myBooks2.add(hm);
>   cur.moveToNext();
> }
>   cur.close();
>
>
>
>
>
>
> On Tue, Mar 6, 2012 at 10:33 AM, moktarul anam <mokta...@gmail.com> wrote:
>
>> Hi Jagruti Sangani,
>> *There is some problem in ur program. one problem may be ur  not closing
>> database after fetching data from database. *
>> *better share ur database code *
>> *
>> *
>> *Moktarul anam *
>> *
>> *
>> On Monday, 5 March 2012 14:50:12 UTC+5:30, Jagruti Sangani wrote:
>>>
>>> hello,
>>> i have use the sqlite databse for storing and retrive the value during
>>> application run.It is work perfectly when i run my apllication on
>>> emulator but when i run my application on phone then when try to get
>>> data from database then it will crash the application.So anybody know
>>> hot to use the sqlit database on phone work.
>>>
>>  --
>> You received this message because you are subscribed to the Google
>> Groups "Android Developers" group.
>> To post to this group, send email to android-developers@googlegroups.com
>> To unsubscribe from this group, send email to
>> android-developers+unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/android-developers?hl=en
>>
>
>  --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to android-developers@googlegroups.com
> To unsubscribe from this group, send email to
> android-developers+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
>

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Reply via email to