Maintenance view Null values

[Former Member]

Hi Experts,

I have created a maintenance view which has the fields Location and characteristics of type ATINN. To the field characterictics i have assinged a foreign key relationship with the table CABN and field ATINN.

While entering the data in the view, if i give some invalid data in the characteristic field and press enter an error message is displayed which is correct. But if i delete the invalid data and press enter a message is displayed 'One entry chosen' and the data is getting saved upon pressing save button. i was expecting an error message but it was not thrown.

I could not understand this behaviour.

Kindly help me out.

Thanks in advance,

Ravi.

[kesavadas_thekkillath]

You should go for table maintenance events in this case.

[Former Member]

Hello Ravi,

In your case I am assuming you have created a TMG then why don't u make this screen field as mandatory in the attributes of the screen of the TMG. It should not then take null values. It's easy and i am sure it must work.

Regards,

Prasenjit Singh Bist

[kesavadas_thekkillath]

When the screen is regenerated , then this change will be vanished.

[Former Member]

Yes, that is true. screen needs to be changed and regenerated. But then as you said the event 05 while creating new values is also helpful. right.

U can check the value

[Former Member]

Hello Ravi, u do one thing u create a TMG and implement the event 05 then ,check the value is not initial for that field , if yes throw error