topic Re: SE11 / Database View / Selection Condition / negative values in Application Development and Automation Discussions

SE11 / Database View / Selection Condition / negative values

Former Member — Fri, 13 Jan 2006 16:18:59 GMT

Hi, fellow programmers,

I want to exclude a certain value from the Selection of

a database view defined in the DDIC.

The table field is defined as INT4 (4-byte integer,

integer number with sign), the value is -7 (minus 7).

I get errors all the time, which seem to be caused by

the minus, no matter if I enter the value as -7 or 7-

( and putting the value into apostrophes is not allowed

anyway for INT-fields). Entering -7 leads to an error

MC753 (selection condition not allowed for SY field),

entering it as 7- leads to error MC750 (Type conflict in selection condition). The long text to MC750 tells me

that for INT4 it is allowed to enter a value with a

leading + or - .

Does anybody know how to cope with this problem?

Thanks in advance

Andreas

Re: SE11 / Database View / Selection Condition / negative values

Former Member — Fri, 13 Jan 2006 16:39:51 GMT

Hi Andreas,

INT4 is allowed to enter -ve values thru table maintenance.

You are getting this error while using SM30(Table maintenance).

I am using _ve values for INT4 and works fine for me.

Lanka

Re: SE11 / Database View / Selection Condition / negative values

Former Member — Fri, 13 Jan 2006 19:46:56 GMT

You can use + or - in DDIC. But it depends sometimes.

I am giving you one example where in you can use only + but not the - sign.

this is a transperant table TSP01 where field RQIDENT and the field type is RSPOID is type int4.

You can use only + ve sign ...you cant use -sign.

But in normal cases you can + or - sign. As you know there are exceptions.

Thanks

jagan

Re: SE11 / Database View / Selection Condition / negative values

Former Member — Fri, 13 Jan 2006 19:50:48 GMT

Hi Andreas,

The table field being INT4 does not allow for the -ve values....check in the dommain of the particular field whether the "Sign" check box is selected.

Below is the help(f1) for the sign field in the domain....

<i>Flag for sign in numerical fields

If fields referring to this domain can contain negative values, this

flag must he set.

When the field contents are output on the screen, the first position of

the output is reserved for a sign. If the flag is not set but the field

contains negative values, problems might occur during screen output. You

can only make entries in this field for data types DEC, FLTP, QUAN and

CURR.</i>

Thanks,

Renjith

Re: SE11 / Database View / Selection Condition / negative values

Former Member — Fri, 13 Jan 2006 19:57:27 GMT

Hi,

I am late in response and Renjith already answered ur question.

Please check the domain of INT4 for Sign Check-box . If checked not set then set the check box then it alloes -Ve values.

"If fields referring to this domain can contain negative values, this flag must be set"

Lanka

Message was edited by: Lanka Murthy

Re: SE11 / Database View / Selection Condition / negative values

Former Member — Mon, 16 Jan 2006 08:24:00 GMT

Lanka, Jagan, Renjith,

thanks a lot for your prompt response.

The sign flag in the domain had already been activated!

What confuses me is that there is no problem at all to

get a minus value into the table. We do that from the

first day since the db table is used. It is just not

possible to enter it as value in the selection condition

of a database view defined in the DDIC.

Nonetheless - thank you all for your comments !

Andreas