Well certainly you have have two records with the same ID, but only if there is more than a single file in play. I can have record X in both file A and file B, but I cannot have a record with a key of X twice in file A without some file corruption.
There is uniqueness within a single file, but not necessarily "global uniqueness". Then again, without some funky programming no other databases have globally unique identifiers either. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 11:38 AM To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, Inc. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/