topic Re: insert statement issues in Application Development and Automation Discussions

insert statement issues

vijy_mukunthan — Wed, 03 Oct 2007 05:57:59 GMT

hi gurus!

i need help regarding insert statement. am using tabstrip in every tabstrip there is ok button which means insert to the table. i have 3 tabstrip when 1st ok button in the 1st tabstrip the all the datas in the 1st tabstrip enters into the table. but when i use 2nd tabstrip when i press ok button the insert statment doesnt work. for all the tabstrip am using the same table . The cursor in the table points only from the 1st how to shift the position for different field. help me with the code.

Thanks in advance

vijay

Re: insert statement issues

Former Member — Wed, 03 Oct 2007 08:45:05 GMT

Hi,

You write your Insert statment in all screens belonging to the concerned Tabs ans also take care of writing this select inside the module written before the endloop in flowlogic of each screens.

suppose you have three fields on screen and their name on the screen are as follows MARA-MATNR MARA-ERSDA MARA-EXTWG. then after loop and before endloop write one module in PAI and in that you write your INSERT command like this.

INSERT MARA.

in this case the structure on screen and table are both same but if the structure on screen fields has diffrent name say ZSTRUCand the fields are

ZSTRUC-MATNR ZSTRUC-ERSDA ZSTRUC-EXTWG respectively then you will write the insert as below in the same module.

INSERT MARA FROM ZSTRUC.

Hope it's clear.

<b>Kindly reward Points if it helps</b>

Thanks and Regards

Tanweer

Re: insert statement issues

Former Member — Thu, 04 Oct 2007 02:36:12 GMT

Hi,

Since there are 3 tabstrip , there must be 3 subscreens .

Which means there will be 3 PBO's and 3 PAI's.

Now, the problem is very simple.

In each PAI of the subcreen you need to put the code for inserting.

That should solve it.

Hope this helps

Regards

Nishant

Re: insert statement issues

vijy_mukunthan — Thu, 04 Oct 2007 10:30:11 GMT

hi am not get 3 pbo and pai am only getting only one pbo and pai in which all the code i have written. i have used tabstrip wizard for the creation of tabstrip.