|
View previous topic :: View next topic
|
| Author |
Message |
madhusudan reddy
Currently Banned
New User
Joined: 17 Sep 2007
Posts: 3
Location: bangalore
|
|
|
|
hi,
how ti handle -811? |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| madhusudan reddy wrote: |
hi,
how ti handle -811? |
1. Look in the manual and find out what it is.
2. If you are doing a SELECT either add more conditions to the WHERE or switch to a cursor. |
|
| Back to top |
|
|
Gautam512
Active User
Joined: 05 Oct 2005
Posts: 308
Location: Vizag / US
|
|
|
|
hi,
need some more info regarding the -811, if u got an error, a brief
description shud be given...
can u post some more details... |
|
| Back to top |
|
|
ksk
Active User
.jpg)
Joined: 08 Jun 2006
Posts: 355
Location: New York
|
|
|
|
Hi,
SQLCODE -811 means, "More than One row Retreived in SELECT INTO".
To remove this error either you have to use cursor to maintain multiple rows or you have to add some more conditions in WHERE clause to get a single row.
If you post your query and results, we can help you more.
Regards,
KSK |
|
| Back to top |
|
|
mauvis
New User
Joined: 27 Jul 2007
Posts: 11
Location: india
|
|
|
|
| use primary key in the where condition |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| use primary key in the where condition |
If the primary key was known and the primary key was the only data needed to meet the data requirement, the topic would not have been started. . .
If all of the data returned from the original select is needed, using a cursor will allow the retrieval of multiple rows.
If the select is further restricted by adding additional predicates, data that now matches the selection criteria will not, possibly giving incorrect/incomplete results. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| I think the original poster has left us. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Gee, Craig,
It hasn't even been a week yet. . .
Other topics from the same TS haven't been replied to either.
Maybe later. . .
d |
|
| Back to top |
|
|
|
|
