topic Re: How to Avoid duplicate entry input in table control in Application Development and Automation Discussions

How to Avoid duplicate entry input in table control

Former Member — Mon, 15 Jan 2007 09:45:38 GMT

I just create a table control on screen with an internal tablefor data maintaining, there are some fields, but the first column fields must be different, that's there can't be 2 records with same first column value.

Is this any way to special in tabel control to avoid this when the second is input?

Or I have to make validate between CHAIN..ENDCHAIN to check one by one, if so, how to make a very effective way?!

Thanks

Re: How to Avoid duplicate entry input in table control

Former Member — Mon, 15 Jan 2007 09:55:51 GMT

Leo,

You can Maintain this validation at internal table level.

Say you are moving ITAB values to table control.

SORT ITAB BY Col1 .

DELETE ADJACENT DUPLICATES FROM TABLE ITAB1

COMPARING col1 .

This code will work for your requirement.

Pls. reward if useful.

Re: How to Avoid duplicate entry input in table control

Former Member — Mon, 15 Jan 2007 09:56:17 GMT

Yes, you need to code in CHAIN...ENDCHAIN. Check in the internal table, if the value already exists then display the error message.