Duplicate IDs in Contact and Company table?

Notes on the new SeedCode Complete template for FileMaker 13
Posts: 129
Joined: Tue Jul 15, 2008 12:41 am
Location: Perth Western Australia
PostPosted: Wed Jan 20, 2016 12:45 am
Hi John,

Just wondering if there is a chance, that the IDs in the ID field in the contact table could be the same as in the ID field in the company table?

In previous version of SeedCode Complete the IDs had a letter prefix related to the table and hence there were always unique.

Just wondering as I want to integrate fmSpark to create letters from the Company table as well as from the Contacts table, but if the IDs would overlap, I would get a mess in the letter history/tracking.

Thanking you in advance.

kind regards

Regine
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Jan 20, 2016 2:50 pm
Both tables use UUIDs for their IDs so while there is a chance that you'd get the same IDs it is so absolutely way out that I don't believe it's credible. For example, developers have created millions and millions of records with these UUIDs and not seen duplicates. Note that we're not using any prefixing so you can't tell if an ID belongs to a contact or company just by looking at it.
John Sindelar
SeedCode

Return to SeedCode Complete 13

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: