SAP Knowledge Base Article - Preview

1953686 - Getting a SQLSTATE=21000 error when running SQL using the OLEDB database driver


When connected to Microsoft SQL Server using the OLEDB database driver ,  and running the following sql:

select *, (select (value_2) from table2 where table2.value_1 = table1.value_1) from table1

PowerBuilder will return the following error:

Select Error:  SQLState=21000

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, < , , < =, > , > = or when the subquery is used as an expression


When connected to Microsoft SQL Server using SNC, a resultset will be returned.  No error is returned.





  • Sybase PowerBuilder
  • Microsoft SQL Server


PowerBuilder all versions


SNC, OLEDB, MS SQL Server, blocking factor, block , KBA , BC-SYB-PB , PowerBuilder , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.