How to insert the record the record at the specific ID in sqlite android

Question

I am newbie to android SQLite and i had a doubt about inserting records in sqlite. How we can insert a record at the pirticular position into the sqlite i,e. if i am inserting first record it will goes to the first position,Then i'll skip the second record and then insert the third record and it will store as record 3 with ID 3 as shown below

 ID value 1 abc 2 3 def 4 ghi 5 jkl 6

Like this can anyone tell me how to achieve this

What about using a 'position' column? In the select you can then order by position like 'select * from table order by position' — Mimmo Grottoli
– Mimmo Grottoli, Commented Dec 11, 2015 at 14:11
Yup i am having the fixed num of rows that is 7 if count was greater than 7 then data in table will be deleted and updated @Opiatefuchs — RD Division Medequip
– RD Division Medequip, Commented Dec 11, 2015 at 14:49

demo_Ashif · Accepted Answer · 2015-12-11 16:20:56Z

Create a method in your database helper class and pass the parameter . Giving you a code sample . Hope it will help you

 public void updateTable(String catID, String data) { try { String sql = "UPDATE data_table SET column_data = " + data + " WHERE cat_id = " + catID; mDb.execSQL(sql); } catch (SQLException mSQLException) { Log.e(TAG, "updateTable >>" + mSQLException.toString()); throw mSQLException; } }

Dreizehn · Accepted Answer · 2015-12-11 14:57:29Z

Your best bet would be to create your table with 3 columns:

_id -> unique identifier of that entry
slot -> this is your 1 - 6 slot, you have to take care about overflow etc.
value -> your value "abc" etc.

e.g.:

CREATE TABLE slots (_id INTEGER PRIMARY KEY AUTOINCREMENT, slot INTEGER NOT NULL, value TEXT);

Basically you could skip the _id column, but it is used in the CursorAdapter implementation, so you would run into trouble there and it doesn't hurt you. As text can be null, you can create a scenario as the one you described above, only your slot's integer value has to be set.

Collectives™ on Stack Overflow

How to insert the record the record at the specific ID in sqlite android

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related