‎2007 Oct 03 6:57 AM
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
‎2007 Oct 03 9:45 AM
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
‎2007 Oct 04 3:36 AM
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
‎2007 Oct 04 11:30 AM
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.