topic Re: Fetch data problem in Application Development and Automation Discussions

Fetch data problem

Former Member — Wed, 29 Dec 2010 07:05:39 GMT

Hi experts,

i have one internal table having some sort of data like

for ex: EMPno EMPNAME SALARY

111 aaa 1000

222 bbb 5000

this is actually report outout...i am getting one popup by user action...

that popup screen is like this

1)EMPNO Employee number

Empname Employee name.

if i select EMPNO i need to display one more popup as

2)OLDvalue newvalue

111 111

222 222

i am getting two popups based on that selections...The problem is in second pop up how to fetch data into oldval and newval columns based on the field selection.

can anybody plz help me...

Thanks,

veena.

Edited by: s veena on Dec 29, 2010 8:06 AM

Re: Fetch data problem

Former Member — Wed, 29 Dec 2010 07:58:23 GMT

set flag indicator to 'X' for new values and for old values set the flag to space. based on flag indicator you can display the popup messages

Re: Fetch data problem

Former Member — Wed, 29 Dec 2010 08:35:02 GMT

Hi Veena,

First of all tell me where does the data of the old value or new value lie:

1. Is it present in the internal table you are talking about.

2. If not in the said internal table then we are left with two options,

i. Either to get the data in the same internal table or some other internal table before hand

ii. Hit a select query after you select the employee no.

I would recommend as it will minimize the no. of hits to the database.

Let me know ...........

Regards,

Abhijit G. Borkar