-----Original Message----- From: [email protected] [mailto:[email protected]] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

