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).
--
Gary Lawrence Murphy <[EMAIL PROTECTED]> TeleDynamics Communications Inc
Business Innovations Through Open Source Systems: http://www.teledyn.com
"Computers are useless. They can only give you answers."(Pablo Picasso)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]