topic Re: duplicate rows in View in Application Development and Automation Discussions

duplicate rows in View

Former Member — Tue, 29 Jul 2008 11:12:38 GMT

hi friends

i hav created a view. it joins 4 tables and i want to display 5 fields.

they are:

mara-matnr

mara-mtart

marc-werks

mard-lgort

makt-maktx.

the prblem is each line item is duplicating in the output.

how i can avoid this?

Former Member — Tue, 29 Jul 2008 11:26:44 GMT

hello,

here's the code.

Function duplicheck()

Dim dr As DataRow

Dim bugid As String

bugid = Nothing

For Each dr In ds1.Tables("form_data").Rows

If dr.Item("bug_id") = bugid Then

ds1.Tables("form_data").Rows.Remove(dr)

bugid = dr.Item("bug_id")

End If

End Function

Reward if Useful.

Regards

Former Member — Tue, 29 Jul 2008 11:29:41 GMT

Hi!

It can be becaue MAKT has a SPRAS field in the key. If it is maintained by more languages, it will have more entries.

The other possible error, if you forget the MANDT field from the JOIN and you have more clients, it could duplicate the entires also.

Regards

Tamá

Former Member — Tue, 29 Jul 2008 11:30:00 GMT

Hi aparna

i'm using View. where i can write the code?

Former Member — Tue, 29 Jul 2008 11:56:16 GMT

Hi,

check this link..

Hope this would hep you.

Regards

Narin