Skip to Content
0
Former Member
Feb 26, 2009 at 04:17 AM

Retrieve data from database

27 Views

Hi friends,

I need a logical solution.

I have 10 yrs employees data. I have upload only basic salary through bdc in database table.

I have a MODULE POOL screen, On screen month ,year and emp. no. (3 text fields) is available.

I have several records of April(2001,2002........2009) ,May(2001,2002, 2003.......2009)..........Jan(2001,2002, 2003..........2009) . To neglect the overwrite of emp no. i have taken (empno, month, year) as aprimary key in database table.

My requirement is When i input month, year and employee no. on screen of particular employee the whole data of current financial year (april 2008 to jan 2009) should be selected from the database table. Not a previous year (2006, 2007, 2008).

One more thing we need to consider if we r extracting data of same year means we want data till Dec.2008 the data should be extract from april 2008 to dec 2008. If we wanna data Till Jan. 2009 the should be retrieve April 2008 to Jan 2009. Not be previous finacial year.

Plz reply as soon as possible.

Regards,

Swapnika