On 20081118 15:25:32, MikeW wrote: > <[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
Excellent! Thanks, I didn't know that... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users