Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

what is the prerequisite to use select single statement

Former Member

‎2007 Sep 19 8:12 AM

0 Kudos
470

Hi...

1...what is the prerequisite to use select single statement?

thanks and regards,

k.swaminath reddy

4 REPLIES 4

Former Member

‎2007 Sep 19 8:16 AM

0 Kudos
122

hi

YOU SHOULD PROVIDE SELECT SINGLE WITH A UNIQUE KEY.

LIKE IF YOU ARE TAKING MAKTX FORM MAKT THEN IN ADDITION TO MATNR YOU HAVE TO GIVE SPRAS ie langueage ALSO TO THE SELECT SINGLE STATEMENT

REWARD IF USEFUL

VIVEKANAND

former_member404244
Active Contributor

‎2007 Sep 19 8:17 AM

0 Kudos
122

Hi,

Prerequistes are

1>where clause is manadatory

2>should specify all the key fields

Regards,

Nagaraj

Former Member

‎2007 Sep 19 8:18 AM

0 Kudos
122

Hello,

SINGLE

The result of the selection should be a single entry. If it is not possible to identify a unique entry, the system uses the first line of the selection. If you use the FOR UPDATE addition, the selected entry is protected against parallel updates from other transactions until the next database commit

Regards,

LIJO

Former Member

‎2007 Sep 19 8:19 AM

0 Kudos
122

Hi,

Fields u r selecting in select statement unique to use select single statement.i.e primary key should be selected while using select single statement.

Regards,

Sankar