-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of J. R. Westmoreland
Is there a way to get an autoincrement field without being a primary key? Yes, you can create a trigger to do this. (This also allows you great flexibility, since you can, for instance, use an increment other than 1, include a check digit, etc., but it's not "built-in" as the one for primary key can be.) Hope this helps, Donald _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
