topic select statement problem in Application Development and Automation Discussions

select statement problem

Former Member — Tue, 20 Jan 2009 08:54:34 GMT

hi,

I have one problem. i am doing ecatt. in that ecatt first time run the ecatt of current date count value is always one. suppose same date we will run the same ecatt that time count has show 02.

how it is possible.

can u explain the logic.

i need following logic

.1)first time of same date

I_PLTXT: Test eCATT 13012009_1

I_NAME1: Test eCATT 13012009_1

2)second time of same date

I_PLTXT: Test eCATT 13012009_2

I_NAME1: Test eCATT 13012009_2

select count(*) from iflo into v_count

where PLTXT like 'Test eCATT%'

and erdat = sy-datum.

i am writing like this but it is not working.

Re: select statement problem

rob_postema — Tue, 20 Jan 2009 09:45:02 GMT

Theoretically it should be working.

maybe there's a problem with the date?

Try to do the select without the date and see if you find any records.



DATA: v_count TYPE i.

SELECT COUNT(*)
  FROM iflo
   INTO v_count
 WHERE pltxt LIKE 'Test eCATT%'.

WRITE: v_count.

Edited by: Rob Postema on Jan 20, 2009 10:45 AM

Re: select statement problem

faisalatsap — Tue, 20 Jan 2009 10:04:25 GMT

Hi, Anitha

Please check first IFLO table is there a text like you are giving in the like statement and ERDAT too, and be sure that it is case sensitive the String you are giving must be fully case matched with the string in table for example

In table PLTXT = aqF you must give it PLTXT like u2018aqFu2019

If you will give like this

PLTXT like u2018aqfu2019 is will not return you any result.

Reply if any problem,

Kind Regards,

Faisal