microsoft / ODBC-Specification

Microsoft ODBC Specification
Other
121 stars 40 forks source link

Does a return escape clause statement qualify as a 'a searched update, insert, or delete statement'? #108

Closed matthew-wozniczka closed 7 years ago

matthew-wozniczka commented 7 years ago

The current spec for SQLExecute says

If SQLExecute executes a searched update, insert, or delete statement that does not affect any rows at the data source, the call to SQLExecute returns SQL_NO_DATA.

So, if a return escape clause query is executed, and the nested DML query does not modify any rows, should we return SQL_NO_DATA?

mikepizzo commented 7 years ago

I would expect an empty result in this case.

mikepizzo commented 7 years ago

Updated spec: "If no rows are affected by the statement, an empty result is returned".