topic Re: regarding the select query in Application Development and Automation Discussions

regarding the select query

Former Member — Fri, 20 Jul 2007 10:43:35 GMT

hi,

select docnum from edidc

into table itab

where direct = '1'

and mestyp = 'OILORD '

and rcvpor = 'WBM6_OIL '

AND CREDAT = '07/10/2007'

and ( status = '03' or status ='30' or status = '22' or status = '06' or status = '12' ).

when iam using this statement the records are not retrieved from the database.

select docnum from edidc

into table itab

where direct = '1'

and mestyp = 'OILORD '

and rcvpor = 'WBM6_OIL '

and ( status = '03' or status ='30' or status = '22' or status = '06' or status = '12' ).

when iam using this statement the records are retrieved from the database.

iam unable to understand the problem.

please give the guidance for this.

it is very urgent.

thanks in advance...

Re: regarding the select query

Former Member — Fri, 20 Jul 2007 10:48:00 GMT

AND CREDAT = '20071002'.

regardss

Peram

Re: regarding the select query

Former Member — Fri, 20 Jul 2007 10:48:14 GMT

The date should be given as '07.10.2007'.Try this and see

Regards,

Reema.

Re: regarding the select query

Former Member — Wed, 25 Jul 2007 03:41:20 GMT

The field "CREDAT" is having values in the format of "YYYYMMDD" in the table EDIDC. So you have use the same format in the query.

For example,

CREADAT = '20070701'

Re: regarding the select query

Former Member — Wed, 25 Jul 2007 07:42:51 GMT

Hi,

Please see the format of date,whatever you give in quotes will be taken as a string input and will be matched char by char...if there is any small diff it will not be selected...CREDAT is of type DATS go to itns data element ie EDI_CCRDAT,

you will see that it is s Date field (YYYYMMDD) stored as char(8)

i think you got your answer.

thanks and regards

vivekanand

Re: regarding the select query

Former Member — Wed, 25 Jul 2007 07:56:15 GMT

date should be entered in yyyymmdd format for the field CREDAT.

regards,

srinivas

*reward for useful answers*

Re: regarding the select query

Former Member — Thu, 26 Jul 2007 08:39:23 GMT

Hi ,

In the table EDIDC the field CREDAT is stored as DD.MM.YYYY.

so, while writing the query you have to use that format.

Try like this.

rgds

harris