Hello John.

I intend to introduce a mandatory Primary Key
column in almost all my tables. For this perpose i
am considering using the result of CoCreateGuid()
API call which is a 16 byte C structure representing
a GUID. I plan to treat the structure as a string and
store it in a column of PK C(16) NOCPTRANS. I hope
with VFP tables it will play out well. What i am
uncertain about is how to implement this scheme on
SQL servers, particularly on Oracle and MS SQL servers.
Could you eluminate me on this?

Thank you.
Kamil.


>Hey Walter,
>
>I have to go back to an earlier point in another (or the same?) thread:
>
>Surrogate keys are the absolute best way to guarantee a unique primary key bar none. Period. And, IMHO, the CoCreateGUID API call absolutely guarantees uniqueness spanning not only the table, but the database, the machine, the network, the freaking world.