‎2007 Jul 11 7:50 AM
Hi All,
My Question is
I Have to created on Domain name zd_stuid type CHAR (10)
Here probelm with value range
I will mention LOWER 10 and HIGHER 10000 and Short text like that while Activation i will get ERROR, How to Overcome that error
Please guide me how to rectify that, reply me the solution for this problem
I look forward to your reply
Thanks & Regards
SEK
‎2007 Jul 11 7:54 AM
you cant give lower limit & higher limit for type CHAR.
if u want to give lower & high limit use type NUMC
Reward points if helpful
‎2007 Jul 11 7:58 AM
What is the error that you are getting? I tried creating a domain in the manner you have mentioned and it is working.
‎2007 Jul 11 8:01 AM
‎2007 Jul 11 8:05 AM
Hi,
The specified fixed value range defines a different set of values in the character set ASCII and in EBCDIC, as the sequence of the individual characters within these character sets differs.
If the specified fixed value range is to be used on computers with the character set ASCII as well as on computers with the character set EBCDIC, divide the fixed value ranges into several smaller ranges which define the same set of values in the two character sets.
For example: if u want 10 to 1000 range u have to divide this numbers like this.
Lower Upper
10 19
20 29
Try like this.
Thanks & Regards
Santhosh
‎2007 Jul 11 8:16 AM
Hi pleas changes it a zd_stuid type CHAR (1) ..
it should be of <b>char 1 not char 10</b>
<b>Limit of interval</b>
The value range of a domain can be limited by defining fixed values. In this case, only the values entered in the fixed values are possible for all the table fields referring to this domain. The fixed values can be single values or intervals.
You can only define fixed values for domains of data types <b>CHAR, NUMC, DEC, INT1, INT2 and INT4.</b>
Dependencies
There is only an input check of the mask for data types CHAR and NUMC. Note that the system only checks single values for NUMC.
if a check table and fixed values are defined for a table field, only values that exist in both the check table and in the fixed values can be entered in the field.
reward points if it is usefull ....
Girish
‎2007 Jul 11 8:25 AM
please see this Domains in SE11 ... and do it similary for yours also ....
<b>MZDAU -> (lenght->7, datatypes->NUMC) 0 - 999990
SUM_N (lenght->2, datatypes->NUMC) 10 - 99</b>
reward points if it is usefull ...
Girish