topic Re: Value Table in Application Development and Automation Discussions

Value Table

Former Member — Wed, 11 Jul 2007 06:50:42 GMT

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

Re: Value Table

Former Member — Wed, 11 Jul 2007 06:54:35 GMT

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

Re: Value Table

Former Member — Wed, 11 Jul 2007 06:58:16 GMT

What is the error that you are getting? I tried creating a domain in the manner you have mentioned and it is working.

Re: Value Table

Former Member — Wed, 11 Jul 2007 07:01:41 GMT

can u mention the error?

Re: Value Table

Former Member — Wed, 11 Jul 2007 07:05:45 GMT

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

Re: Value Table

Former Member — Wed, 11 Jul 2007 07:16:17 GMT

Hi pleas changes it a zd_stuid type CHAR (1) ..

it should be of char 1 not char 10

Limit of interval

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 CHAR, NUMC, DEC, INT1, INT2 and INT4.

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

Re: Value Table

Former Member — Wed, 11 Jul 2007 07:25:50 GMT

please see this Domains in SE11 ... and do it similary for yours also ....

MZDAU -> (lenght->7, datatypes->NUMC) 0 - 999990

SUM_N (lenght->2, datatypes->NUMC) 10 - 99

reward points if it is usefull ...

Girish