topic Re: Simple Select Single statment doubt : please help in Application Development and Automation Discussions

Simple Select Single statment doubt : please help

Former Member — Tue, 14 Aug 2007 16:30:53 GMT

Dear SAP,

One simple question !!

What happens, If I dont pass all the key values in select single statement.

which data would it bring, the first occurence in DB table ?????

Cont..

And what happens if, I use select single without passing all keys (missing POSNR) but using it in a loop and giving condition as posnr > 900000. does this always bring same values.

Please let me know. Thank you.

Regards

venkat

Re: Simple Select Single statment doubt : please help

Former Member — Tue, 14 Aug 2007 16:33:30 GMT

SELECT SINGLE only gather one value, so it's the first value it gets from the DB...If you don't specify any key, your going to get the first record of the DB...

In a LOOP is you don't specify the POSNR, your always going to get the same value....

Greetings,

Blag.

Re: Simple Select Single statment doubt : please help

Former Member — Tue, 14 Aug 2007 16:34:35 GMT

If you don't pass all key fields in SELECT SINGLE there will be multiple records for those condition and it fetches the first record

If you won't pass POSNR in a loop, then for a single doc there will be multiple items and always the first item only selected

if a value exists greater than 900000, then it may consider that value

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Simple Select Single statment doubt : please help

Former Member — Tue, 14 Aug 2007 16:35:19 GMT

That is not recommened if do not have primary key field then do not use select single.

try to use select up to 1 row instead of select single

Thanks

Seshu

Re: Simple Select Single statment doubt : please help

Former Member — Tue, 14 Aug 2007 17:26:19 GMT

Hi Venkat,

It wil behave in the similar way as you thought of.

When you don't have the full key then you should use SELECT...UPTO 1 ROWS ..ENDSELECT as this is much faster in such scenario.

Regards,

Atish

Re: Simple Select Single statment doubt : please help

Former Member — Tue, 14 Aug 2007 18:15:16 GMT

Hi All,

Thanks for your replies !! I am alloting points to all of you.

closing thread !!

Regards

venkat