Hello Razzak, Thanks for your reply.
As of August, 2014 foreign-trained candidates must register with an external agency before applying for our exams. The agency provides them with a unique alphanumeric identifier which must be included in their applications for our exams. We want to verify that the identifier is unique in our database. However, current Canadian-trained candidates (about half) and all candidates who started our process before August, 2014 do not have this identifier. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: May-05-16 2:29 PM To: [email protected] Subject: Re: [RBASE-L] - Unique or NULL At 02:07 PM 5/5/2016, Stephen Markson wrote: >What is the best way to implement a column that can be null, but if not >null, must be unique? Stephen, The first and most important question: What is the objective? If your goal is to have a unique column identifier that ultimately represents a unique Row ID, I suggest to look into adding a column type GUID with expression defined as (CVAL('GUID')). Data type GUID is a binary global unique identifier to store unique values, which is represented as a 36-character hexadecimal string. Note: GUID data type is specific to R:BASE eXtreme 9.5 (64) and R:BASE X Enterprise (Version 10). Very Best R:egards, Razzak. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
