Tagged Questions

Android uses SQLite database to store and retrieve data persistently.There has been many code snippets[question regarding] which can be of `how to to create and use the SQLite database with android`.

learn more… | top users | synonyms

0
votes
0answers
22 views

Select rows from SQLite which contains given values

Problem Description I have an SQLite database which has category_codes column which can be formatted as follow: 1, 45 98765, 12 545, 1, 898, 741, 78 45 87, 741 ...... Question I have a string ...
-4
votes
0answers
21 views

Insert values in table in sqlite in android [closed]

someone please help me in inserting values in table in sqlite . I have to store some question and his answer in database i had already created table but i don't know how to insert values in these ...
0
votes
1answer
10 views

Strange result in SQLite query

I´m getting a strange result from a SQLite query. The query is the next one: SELECT rule FROM rules WHERE idRule = (SELECT idRuleForeign FROM rulesXfilter WHERE idFilterForeign = ...
0
votes
3answers
38 views

Can't get SQLite writable database

I'm trying to implement android SQLite usage design pattern that ensures one opened SQLiteDatabase instance per application. public class BaseDataSource { private static final CustomSQLiteHelper ...
0
votes
2answers
29 views

How to get saved value in sqlite database to list in Android?

I am trying to get saved values in a list. I am creating anotepad and I want when anybody open notepad every saved list display on homepage in a list. I have successfully saved the value in a ...
0
votes
2answers
41 views

Database not created in android

I have made a simple database application in android using DBhelper,I have put 2 Edittexts and 2 buttons,now i want is when i press "save" the values of 2 edittexts should be saved in database.I have ...
0
votes
0answers
12 views

Create Android Sqlite data base from SenchaTouch

Hi I am new bie to sencha touch I have requirement for creating the andorid sqlite database from sencha touch,I am building the andorid apk with phone gap ,can i use phonegap api in sencha touch for ...
1
vote
0answers
26 views

need equivalent query in SQLite [duplicate]

what is the equivalent sqlite query of the following statement? Data = _db.EMP_TRACKING.OrderBy(m => m.ID).Skip(page - 1).Take(PageSize) Or What will be the query for the following scenario?? ...
0
votes
1answer
165 views

Android Content Provider with multiple tables unknow uri error

I followed a tutorial about sqlite and content providers but it had only examples for a single table, I eventually managed to figure how to expand that provider to include two tables and everything ...
0
votes
1answer
17 views

onLoadFinished() receives a null cursor

I'm trying to populate a ListView in my activity using a ContentProvider that I created, but when the onLoadFinished() method is called, it receives a null Cursor. (The CursorLoader is not null ...
1
vote
1answer
23 views

Android Adapt Data from a SQLite Database to a Listview

EDIT: After spending almost all day on this OutOfMemory Error I was getting, turns out I simply wasnt advancing a cursor. However, I still wish to obtain an answer for my question below. To clarify, ...
0
votes
2answers
35 views

How to place a THREAD with INFINITE FOR LOOP inside a background SERVICE

i am developing application that will sends birthday wishes automatically based on the birthday date with time registered by wisher. i have created a thread with infinite for loop that will get the ...
0
votes
1answer
15 views

Accessing db file while debugging on real device

Is it restricted (security reasons etc.) or something wrong with my dev environment? I can't see inside "data" folder.
0
votes
1answer
21 views

How to use query in android sqlite database

In my application previously I was retrieving data from table which is in sqlite database. So I was using following way to get the data: cursor = database.query("CIRCLE", new String[] { "CIRCLE_ID", ...
0
votes
0answers
37 views

Android. Empty Cursor

I copied database file from device and opened in SQLite client. Same query in the SQLite client returns results as expected but Android sometimes returns empty cursor. I can't explain why sometimes ...

1 2 3 4 5 … 68
15 30 50 per page