topic Re: repeatable in Application Development and Automation Discussions

repeatable

Former Member — Fri, 24 Aug 2007 10:06:59 GMT

hi guru's,

i want to disply repeatable records ,which will available in database.how to retrive only repeatable records.

give me code corresponding that

thanks in advance

former_member582701 — Fri, 24 Aug 2007 11:02:01 GMT

Hi surendra,

I think it doesnt exist. You have to retrieve all table and do a loop.

Select * from DATABASE into itab.

Sort itab order by fields.

Read table itab index 1 into wa2_itab.

numrecords = 0.

Loop at itab into wa_itab.

if wa_itab <> wa2_itab. " or fields you need to compare

if numrecords = 1.

append wa2_itab into otab2.

endif.

move wa_itab to wa2_itab.

numrecords = 1.

else.

numrecords = numrecords + 1.

endif.

endloop.

reward points if it help u

best regards

Clemenss — Fri, 24 Aug 2007 12:42:57 GMT

Hi surendra raju,

what is your personal definition of "repeatable records"?

Not given any context at all...

Regards,

Clemens

Former Member — Fri, 24 Aug 2007 12:48:28 GMT

probably you mean duplicate reports?

Former Member — Fri, 24 Aug 2007 12:48:32 GMT

probably you mean duplicate reports?

Clemenss — Fri, 24 Aug 2007 13:53:56 GMT

duplicate reports?

duplicate recorts can not exist in the database because that would imply a duplicate key. Duplicate keys are not defined in relational database.

Regards,

Clemens