topic inconsistency when appending a table in Application Development and Automation Discussions

inconsistency when appending a table

Former Member — Wed, 16 Jan 2008 13:31:58 GMT

i did an append in a standard table because of some requirement

lets say i append with field name XXXX

but when i go the se11 and input xxxx NE space (this should return me all field where xxxx is empty) i get 30 record

and when i go the SE11 and select same thing without putting any condition in xxxx (this should again return me all field where xxxx ie empty ) i get 100 record

what i discover is that in SE14 and do a check in the database the field XXXX not null and default value has not been assign anything .

This i get inconsistencies when selecting record . anyone encounter this problem before please advise

Re: inconsistency when appending a table

JozsefSzikszai — Wed, 16 Jan 2008 13:39:30 GMT

hi,

did you carry out the 'Activate and adjust DB' functionality in SE14?

Re: inconsistency when appending a table

Former Member — Wed, 16 Jan 2008 13:48:46 GMT

i tried but i got the message

"No authorization for action: CNV with object:"

and the action got cancel. may be i don't have enough rights to do so. is there any other way

Re: inconsistency when appending a table

Former Member — Wed, 16 Jan 2008 13:53:08 GMT

by the way when you click on activate and adjust database after that when do you do ?

Re: inconsistency when appending a table

JozsefSzikszai — Wed, 16 Jan 2008 13:54:01 GMT

no other way. this is a must to do.

you can do two things:

1. someone else (who has proper auth.) does this for you

2. you auth will be fixed and you do on your own

Re: inconsistency when appending a table

Former Member — Wed, 16 Jan 2008 13:58:06 GMT

ok may be i found a user who had more authorization

after i click on adjust a pop-up appear with "request:"Adjust""

i click on yes what is suppose to happen?

Re: inconsistency when appending a table

JozsefSzikszai — Wed, 16 Jan 2008 14:13:58 GMT

the table will be adjusted with the new filed (I guess you inserted the new field not at the end), when it is ready, try to display the data again.