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.

Reply via email to