Inserting record in sqlite results in duplicate record

Question

When i insert one record then duplicate entry is generated that means total two same entries are display. My query for select statement is following: How to make distinct record???

Cursor cur = db.query("timer", null, null, null, null, null, null);

check: [select distinct value in android sqlite](http://stackoverflow.com/a/11219399/379693) — Paresh Mayani, Jan 01 '13 at 06:25

score 0 · Answer 1 · answered Jan 01 '13 at 06:25

0

To make a distinct selection define a boolean Variable like :

private boolean Distinct = true;

then change your query to :

c = db.query(Distinct,DATABASE_TABLE,cols,null,null, null, null,
                    null,null);

answered Jan 01 '13 at 06:25

Arash GM

10,166
6
57
74

this is the way that u can make a distinc selection if you have another problem with your code plz provide your java code,maybe we can help you – Arash GM Jan 01 '13 at 06:30

Inserting record in sqlite results in duplicate record

1 Answers1