Jean-Denis Muys wrote: > On 10/7/09 21:35 , "Adam DeVita" <adev...@verifeye.com> wrote: > > >> One can also get a mess if Mr. Red and Mr Black both get new customers, and >> enter them and they both get the same ID because the auto-generated int >> happens to be the same. Both copies get updated with the other guy's data, >> they then get annoyed and enter the stuff again and it happens over again, >> but now there are N entries of the other guy's customer in the database >> depending on how many times they do it. >> >> > > I solve this problem the following way: > > New records ID is not set by the local client who creates the new record, > but by the central database.
Another solution is to use a GUID instead of an integer. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users