At 09:20 AM 29-08-02 +0800, Chooi Ting wrote:

>Hi,
>
>good days!
>Below is my sql query:
>UPDATE SUMMARYEVENT SET INITIALIZED = 1 WHERE SUMMARYTYPE = 2

This statement on its own is not a SELECT query and would not return the
reported error if submitted interactively. So, in your client code, you
are somehow trying to "open" a query which should be executed. This will
be caused by some kind of wrong handling in your client code. (For
example, where you are using a TUpdateSQL in Delphi to perform updates to a
linked dataset.) Provide more information!

>Then, I got this error message:
>Statement Failed, SQLCODE = -811
>
>multiple rows in singleton select
>
>However, if I use the same query with different summary type, eg
>UPDATE SUMMARYEVENT SET INITIALIZED = 1 WHERE SUMMARYTYPE = 3
>
>Then, the query executed successfully.
>Can anybody explain this ? Please help.

Simply, the client request involved a searched update and, in this
instance, it was able to uniquely identify the searched row *in the
database* via the SUMMARYTYPE. Amongst other things, it means your table
(in the database) has only one row where this criterion is met.

It's easier to help when you provide enough information to identify the
problem..

heLen