node-odbc icon indicating copy to clipboard operation
node-odbc copied to clipboard

Error executing delete sql when no rows are deleted

Open snotmare opened this issue 7 months ago • 9 comments

Hello!

I have odbc 2.4.8 installed and have noticed an error when deleting data. I believe I should NOT be receiving this error.

The error occurs when executing a delete statement and no rows are actually deleted. For example...

  1. Execute a delete statement to delete a row that does exist (delete works)
  2. Run the same exact statement to attempt to delete the now-deleted row (fails with an error)

I think odbc should NOT throw an error, but instead simply return a count of 0 since no rows were deleted. Here is a screen shot of the error I received. Notice that the odbcErrors array is empty.

image

Thanks all!

snotmare avatar Jul 12 '24 20:07 snotmare