Re: System.Data.SqlClient.SqlException: Subquery returned more than 1 value.

the posted statement has no subquery, check to see if a trigger exists on
the table, which might throw the error, otherwise, you do not have the
correct failing sql cmd text.

-- bruce (sqlwork.com)

"Rod" <1gandalf@xxxxxxxxxxxxxxxx> wrote in message
news:OkKX%23jMXFHA.1044@xxxxxxxxxxxxxxxxxxxxxxx
>I have a client site where the code below has been working happily for at
> least four months. The site is using SQL Server 7. The code is ASP.NET
>
> Last week an error appeared related to the following SQL statement.
>
> INSERT INTO OrderItems (ClientID, ProductID, OrderHeaderID, Quantity,
> Dispatched, BackOrdered) SELECT ClientID, ProductID, 1371 AS
> OrderHeaderID,
> Quantity, Dispatched, BackOrdered FROM Basket WHERE RequisitionID = 1369
>
> The error message is:
>
> System.Data.SqlClient.SqlException: Subquery returned more than 1 value.
> This is not permitted when the subquery follows =, !=, <, <= , >, >= or
> when
> the subquery is used as an expression...
>
> There appears to be nothing wrong with the SQL Statement, indeed if run in
> Query Analyser it executes correctly. I cannot see how the error message
> relates to the code at all. Nor do I understand why the code worked for
> four months and has now decided to fail.
>
> The context in which the code is called is the procedure below where the
> SQL
> statement is passed to the parameter strSQL.
>
> Private Sub executeSQL(strSQL as String)
> Dim conn As New System.Data.SqlClient.SqlConnection(CONN_STRING)
> Dim cmd As New System.Data.SqlClient.SqlCommand(strSQL, conn)
> cmd.Connection.Open()
> cmd.ExecuteNonQuery()
> conn.Close()
> End Sub
>
> Any help would be greatly appreciated.
>
> Rod.
>
>
>


.

Relevant Pages

  • Query Multiple Tables
    ... Actually the subquery is just pure sql language, ... query, switch to SQL view, copy the text, and then paste ... >DMax in a query criteria in the same way. ...
    (microsoft.public.access.queries)
  • Re: Trouble with query
    ... What you have here is known as a correlated subquery. ... "outer" query, the "inner" query is processed, based on the correlation ... Various books on SQL cover this. ... #transtype ty on tr.idtranstype = ty.idtranstype ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Division
    ... however, is that you CANNOT, then have any brackets in your subquery. ... brackets and parentheses within the subquery ... the SQL text remains identical. ...
    (microsoft.public.access.queries)
  • Re: Help with derived table SQL statement in Access
    ... Table aliases increase the clarity of SQL by explicitly noting each ... If I remove the where clause from the subquery, it works, but I get ... SELECT expression on the FROM clause, but that is just that, a table ...
    (microsoft.public.access.queries)
  • SQL error
    ... I am attempting to permit the user to select 1 of 3 options in the display of database records. ... OptSchedule(0) is titled: ... The SQL statement worked before I included the sSchedule variable also. ... strSQL = "SELECT LastName, FirstName, ClientID, " ...
    (comp.lang.basic.visual.misc)
Quantcast