topic Re: Data Fecthing in Application Development and Automation Discussions

Data Fecthing

Former Member — Thu, 14 Dec 2006 08:53:03 GMT

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

Re: Data Fecthing

Former Member — Thu, 14 Dec 2006 08:55:41 GMT

Hi,

Try this...

SELECT *

FROM ztable

INTO TABLE itab

WHERE fdate GE p_fdate

AND tdate LE p_tdate.

Regards

Wenceslaus

Re: Data Fecthing

Former Member — Thu, 14 Dec 2006 08:56:56 GMT

parameters : p_fdate like ztable-fdate,

p_tdate like ztable-tdate.

select *  from ztable into table itab where fdate = p_fdate and
                                                           tdate = p_tdate.

Message was edited by:

Chandrasekhar Jagarlamudi

Re: Data Fecthing

gopi_narendra — Thu, 14 Dec 2006 08:57:33 GMT

select seqno fdate tdate from <TableName>

into table it_tablename

where fdate GE p_fdate

and tdate LE p_tdate.

Regards

- Gopi

Re: Data Fecthing

Former Member — Thu, 14 Dec 2006 09:00:34 GMT

I Think This condition will fail if I have given third condition .

Re: Data Fecthing

Former Member — Thu, 14 Dec 2006 09:03:29 GMT

I hope this wouldn't fail.

Since the TDATE param is less than the value for the record

Regards

Wenceslaus

Re: Data Fecthing

jayanthi_jayaraman — Thu, 14 Dec 2006 09:07:16 GMT

Hi,

select * from db into table itab

where tdate GT p_tdate.