Gary Lawrence Murphy <[EMAIL PROTECTED]> writes:
> Does Torque provide (or plan to provide) support for datatype domains?
>
> Domains are a means to define datatypes at the top of the script; what
> I'd like to do is have a section in the XML that reads
>
> <domain name="SHA" type="CHAR" length="20" />
>
> and use it as
>
> <column name="OBJECT_ID" type="SHA" />
>
> Then, in Oracle or Sybase, this would resolve to something like
>
> execute sp_addtype OBJECT_ID, 'char(20)'
>
> whereas, in MySQL (where I don't think domains are supported) Torquen
> would need to resolve and substitute these user-defined types in the
> SQL generation.
>
> This allows me to make global datatype changes with semantic scope,
> for example, to change the length of all my OBJECT_ID's without also
> changing all other domains which just happen to resolve to char(20).
It doesn't currently support such a feature, but I would be +1 on its
addition if you submitted such a patch.
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
