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
6 views

Unable to Copy Whole SqLite Database at Destpath Only 3072bit Copied

I am trying to copy a database named "loveSMS" from the asset folder to the application databases folder, but it is not working... try{ String ...
0
votes
1answer
22 views

android.database.sqlite.SQLiteException syntax error (code 1)

I try to switch ID for 2 rows in my database. I get syntax error (code 1) on this line: ourDatabase.update(LIVE_TABLE, cv, whereClause, whereArgs); Its strange becuase if this the row i look for ...
0
votes
2answers
32 views

Inserting data to record in sqlite

I have to make an Android application in which i have to store predefined question and answer, using sqlite to store data. I found tutorials in which values are inserted every time we run the ...
-2
votes
0answers
39 views

how can i connect SQLite and MYSQL

I have installed sqlite3 in my local sytem and mysql in the main server.here sqlite for off-line support when the internet connectivity is closed user can retrieve and send the data from local ...
1
vote
1answer
39 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
23 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
13 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
2answers
30 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
44 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
3answers
40 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
0answers
14 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
18 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 ...
0
votes
2answers
37 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
22 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", ...

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