01-11-2008 4:31 AM
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
01-11-2008 4:34 AM
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
01-11-2008 4:40 AM
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.
01-11-2008 5:14 AM
Hi,
I got that,
Actually when I replaced COUNT(*) by COUNT ( * ) , problem is resolved...
Thank u so much for your advice.
Regards,
Amey