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 AddressBookMemb er
SET Bounced = 0
WHERE (UserID = @UserID) AND (AddressBookID = @AddressBookID) AND (Bounced = 1)

The parameters are defined as:

<Parameter AllowDbNull="Fa lse" AutogeneratedNa me="UserID" ColumnName="Use rID" DataSourceName= "manymail.dbo.A ddressBookMembe r" DataTypeServer= "int" DbType="Int32" Direction="Inpu t" ParameterName=" @UserID" Precision="0" ProviderType="I nt" Scale="0" Size="4" SourceColumn="U serID" SourceColumnNul lMapping="False " SourceVersion=" Original">
</Parameter>
<Parameter AllowDbNull="Tr ue" AutogeneratedNa me="AddressBook ID" ColumnName="Add ressBookID" DataSourceName= "manymail.dbo.A ddressBookMembe r" DataTypeServer= "int" DbType="Int32" Direction="Inpu t" ParameterName=" @AddressBookID" Precision="0" ProviderType="I nt" Scale="0" Size="4" SourceColumn="A ddressBookID" SourceColumnNul lMapping="False " SourceVersion=" Original">
</Parameter>


The query get called with the following tag:

Dim abMember As New AddressBookMemb er
abMember.Update BouncedToUnboun ced(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