Once more: Subquery returned more than 1 value.

[abednegoo]

Hi All,

I tried to find the solution for my problem, but i couldn't find it. If my problem is already solved somewhere, please provide me the link...

I'm not a developer myself, but the application manager who needs to solve the issue :) I have got a problem with out software. It throws an error (Subquery returned more than 1 value, blablabla) at me and I cannot see why.

I have this data which is stored in an XSD file. The query is the following:

UPDATE AddressBookMember
SET Bounced = 0
WHERE (UserID = @UserID) AND (AddressBookID = @AddressBookID) AND (Bounced = 1)

The parameters are defined as:

<Parameter AllowDbNull="False" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="manymail.dbo.AddressBookMember" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="AddressBookID" ColumnName="AddressBookID" DataSourceName="manymail.dbo.AddressBookMember" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AddressBookID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AddressBookID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>


The query get called with the following tag:

Dim abMember As New AddressBookMember
abMember.UpdateBouncedToUnbounced(UserID, AddressBookID)



The query isn't stored as a trigger, and cannot be stored as a trigger in the database (for now).

Does anyone know how to re-arrange the query so that it works like it should?

Thanks many times!
Tim