From: Nando D. <na...@de...> - 2010-10-23 17:51:41
|
Milan, Michael, >> 1. UDD (user defined domain) - explicitly defined using CREATE >> DOMAIN 2. SD (system domain) - RDB$ domain with a name, not a >> number after RDB$, say RDB$SYSTEM_FLAG 3. AD (automatic domain) - >> assigned for user tables when column is created without explicit >> domain RDB$123 >> >> - only UDD should be listed in tree and shown in >> FieldPropertiesDialog - when both domain and datatype is shown for >> column in tree or property page, we should show UDD and SD if >> available - when extracting DDL, the priority should be: UDD, SD, >> datatype string, AD >> >> In this last case AD is shown if datatype is not detected. >> Shouldn't ever happen unless system tables are modified directly. >> >> Now, I don't see any of these requires that we have 3 collections. >> I see only a need for two, one containing UDDs and other containing >> SDs and ADs. Difference between SD and AD is only observed for a >> particular domain, never as a collection. > > Nice summary, I completely agree with it. I'll see what I can do. I agree as well, but I'd go to the point of saying that ADs are not even domains at all, and FR shouldn't bother about them when reading RDB$FIELDS. They aren't needed anyway, except in this case: >> In this last case AD is shown if datatype is not detected. I can't imagine how it can ever be. -- Nando Dessena |