topic Re: message when INSERT/DELETE table in Application Development and Automation Discussions

message when INSERT/DELETE table

Former Member — Mon, 19 Nov 2007 10:32:31 GMT

hi Experts!!

i am working on a screen in which i have some Alv DISPLAY OF ATABLE AND WHEN I INSERT OR DELTE FROM THE TABLE, immdiate after insert or delte i need to display a message with sy-dbcnt detail.. for this

i have creeted a screen to and taken i/p o/p fields in that naming variable for same INSIP and passing the valus eo sy-dbcnt to that field in screen PBo. but i am not getting the Sy-dbcnt values.

but when i debug i get the value in the Variable INSIP but not dispaling when i run it..plz help me soooon

please help me wats wrong..

thank you

Re: message when INSERT/DELETE table

Former Member — Mon, 19 Nov 2007 10:37:31 GMT

logic

case sy-ucomm.

when delete.

DESCRIBE TABLE itab LINES lin

msg s0001 with lin.

when insert.

DESCRIBE TABLE itab LINES lin

msg s0001 with lin.

endcase.

Re: message when INSERT/DELETE table

Former Member — Mon, 19 Nov 2007 10:50:59 GMT

hiii.

actuly i am editing an GRID where in i m entering then valuse to update by using SAVe buttun. when save is presed i need this message to be displayed. i have used describe table in erlier stage to find whether user hasss inserded or deleted the row.

since after insert /delete i am passing sy-dbcnt to the message screen field.. i am geting valuse of sy-dbcnt in varible fiel but when i run the program it only displye sthe screen but not sy-dbcnt valuse..

plz help me

Re: message when INSERT/DELETE table

former_member404244 — Mon, 19 Nov 2007 11:05:16 GMT

hI,

After u press save button u r updating the table..so after that statement u write the seelct quuery

Update ztable.

select count * from ztable into v_count.

if sys-subrc eq 0.

give message with v_count.

endif.

Rewrad if helpful.

Regards,

Nagaraj

Re: message when INSERT/DELETE table

Former Member — Mon, 19 Nov 2007 11:23:32 GMT

HII

I TRIED WITH THIS

DESCRIBE TABLE itab LINES lin

msg s0001 with lin.

HOW TO WRITE MESSAGE WITH USING LIN.

I NEED TO CREATE IT IN MESSAGE CLASS..PLZ EXPLAIN ME

Re: message when INSERT/DELETE table

Former Member — Mon, 19 Nov 2007 11:29:37 GMT

in the message class create some text using & like.

001 No of lines inserted &

now message s001 with lin

& symbol will get replaced by value of lin

*reward if answered