<[EMAIL PROTECTED]> writes: Can't make the 'name' column > 'unique' as two clients may have the same name. Can't make > the 'id' column 'unique' as a client may have more than one > name...
However you can specify that the name/id pair is unique ... PRIMARY KEY (name, id) Regards, MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
