Skip to Content
0
Former Member
Oct 16, 2006 at 02:48 PM

small issue in dialog program

21 Views

Hello all,

i have a requirement in dialog programming.

I have to modify a record a record which exist in zatble.

For each record , i have a header info, item details.

for header iam ok , i can use modify.

for item details i have like

itemno material materialdesc quantity

1 m1 pqr 12

2 m2 def 9

3 m3 abc 2

4 m4 xyz 1

item no and material are my primary keys.

so iam retrieving this data from a z table and have to update.

may be i need to delete 3 record and modify 2 record,i would do that based on the selectionfrom table control

itemno material materialdesc quantity

1 m1 pqr 12

2 m2 def 19

3 m4 xyz 1

now i have deleted 3 record and modifed 2 with increase in quantity and the itemno are changed

I have ths data in my internal table.

iAM USING MODIFY STATEMNT WHEN I SAVE THE DATA INTO DATABASE TABLE.

i SEE THE FOLLOWING DAT AIN MY ZTABLE

1 m1 pqr 12

2 m2 def 19

3 m3 abc 2

4 m4 xyz 1

3 m4 xyz 1

THOGHT I NEED ONLY THESE DATA TO BE PRESENT IN MY ZTABLE

1 m1 pqr 12

2 m2 def 19

3 m4 xyz 1

Any help or suggestions regarding this

Thanks

Suchitra