Skip to Content
0
Former Member
Dec 14, 2006 at 08:53 AM

Data Fecthing

31 Views

Dear All ,

I Have three fields in data base table .

SEQNO - Sequence Number

FDATE - From date

TDATE - to date

now suppose i have one record like

001 13.12.2006 27.12.2006.

In my Program I have given selection screen with parameters for FDATE and TDATE .

user may enter FDATE = 13.12.2006 .

TDATE = 13.12.2006 .

or He may Enter FDATE = 12.12.2006 .

TDATE = 14.12.2006 .

or He may enter FDATE = 17.12.2006 .

TDATE = 18.12.2006 .

for all above cases of selection I need to fetch the record given above .

How should I write the database Query