General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>As Craig said, that may not be the best approach. Besides AutoInc fields you can have a counter table or you can use a GUID (though they are too lonmg as keys for most of my uses :).
I guess that I wasn't clear. I have 20 locations that will generate their own Primary Key and then sync the records to one location. This means, at least in my understanding, that I can't use AutoInc, or a counter table.
I could use a 32 character GUID, but I thought that I read that on fast systems it is possible to get duplicate GUID's.
Comments appreciated.
DJ
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only