On 06.09.2013 20:52, Igor Tandetnik wrote:
On 9/6/2013 1:05 PM, ibrahim wrote:
Perhaps you should really try it out cause my suggestion is totally
different from yours it uses a temporary table it works.
create table t1 (pk integer primary key, name text, seq integer) ;
You missed the whole "Name/Sequence pair of columns is defined as
UNIQUE" part. Make it
create table t1 (pk integer primary key, name text, seq integer,
UNIQUE(name, seq) ) ;
See how well your technique is working for you now.
I missed that part.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users