topic Re: select count(*) statement in ABAP in Application Development and Automation Discussions

select count(*) statement in ABAP

Amey-Mogare — Fri, 11 Jan 2008 04:31:48 GMT

Hi,

Im writing following statement in my Function module,

select count(*) into l_count

from user_master

where username = l_username and

process_type = processtype and

password = oldpassword.

And there is one entry in table user_master.

But still, I'm getting l_count as zero..

Can somebody help me with this.

Regards,

Amey

Re: select count(*) statement in ABAP

Former Member — Fri, 11 Jan 2008 04:34:42 GMT

Once Check the Values u r passing to the Select. Actually SAP Stores the values on the tables in Capital Letters. U would have given ur password in small letters.

awrd points if helpful

Bhupal

Re: select count(*) statement in ABAP

Former Member — Fri, 11 Jan 2008 04:40:22 GMT

select count(*) into l_count

from user_master

where username = l_username and

process_type = processtype and

password = oldpassword.

Use group by option...

Like this....

select count(*) into l_count

from user_master

where username = l_username and

process_type = processtype and

password = oldpassword group by username.

Re: select count(*) statement in ABAP

Amey-Mogare — Fri, 11 Jan 2008 05:14:54 GMT

Hi,

I got that,

Actually when I replaced COUNT(*) by COUNT ( * ) , problem is resolved...

Thank u so much for your advice.

Regards,

Amey