Hello,
First , I have defined a domain named PID as INTEGER with this following
check contraint:
PID between 1 and 45
After that, I have assigned this domain to a column named NUMERO into a
table named TAB1.
At this end, I have generated the DDL file (SQL script) in order to create
my data base.
The contain of this DDL file was wrong as shown bellow:
CREATE TABLE TAB1(
...
numero INTEGER,
...
);
ALTER TABLE TAB1 ADD CHECK (PID between 1 and 45); // this line
seems wrong
but I was expected the following result:
CREATE TABLE TAB1(
...
numero INTEGER CONSTRAINT CKC_NUMERO_PID check (numero between 1 and
45),
...
);
If someone could tell me the right way to do that, or if you have
any rose project (mdl file) as example, I will be very please.
Christian
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
