Simon,
Thank you for your quick responses.
I have attached sample db. I tried to simulate with test application.
But, I could not.
Please find the attached db, which has only one table.
Based on schema and data, you can identify the duplicate issue. columne
2 and 3 are duplicated.
Thanks in advance,
Durga.
On Thu, Jan 12, 2012 at 3:57 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 12 Jan 2012, at 10:14am, Durga D wrote:
>
> > create table if not exists t0 (
> > h integer primary key autoincrement,
> > t0info text, unique(t0info));
> >
> > t0 table allows duplicate t0info column, when in transaction.
> >
> > how to avoid duplicates for t0info column.
>
> If your table was created with that command, then it should not allow
> duplicate t0info columns. Did you perhaps create it first without the
> 'unique' requirement, and now your 'CREATE TABLE IF NOT EXISTS' command is
> doing nothing ?
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
