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: 

diff b/w SECELT SINGLE * AND SELECT UPTO ONE ROW

Former Member

‎12-25-2006 2:08 PM

0 Kudos

HI,

WHAT IS THE MAIN & IMPORTANT DIFFERENCE BETWEEN SECELT SINGLE * AND SELECT UPTO ONE ROW

2 REPLIES 2

Former Member

‎12-25-2006 2:22 PM

0 Kudos

Hi,

"SECELT SINGLE * " has only one communication with databse. but "SELECT UPTO ONE ROW" has two communcation with databse.

Ashven

uwe_schieferstein
Active Contributor

‎12-25-2006 6:26 PM

0 Kudos

Hello Swapna

I use the SELECT SINGLE statement when I need a single entry from a database table where I have all key field values availabe. After executing the statement I have the details of the entry available (i.e. stored in a variable).

I use the SELECT UP TO ONE ROWS statement if I need to check that at least a single entry having certain values exists in the database table. Since I am not interested in details of the entries I do not have any variable filled with details.

Regards

Uwe