Databricks sql using odbc issue

[DBUser2]

Hi,

I'm connecting to a Databricks instance on Azure from a Windows Application using Simba ODBC driver, and when running SQL statements on delta tables, like INSERT, UPDATE, DELETE commands using Execute, the result doesn't indicate the no. of rows affected, it is always -1. Is there a way to get that information back when running the commands? Any help is greatly appreciated. Thanks!!

[DBUser2]

Thx for replying. So, is there an alternative to using Execute to run DML statements and find out  the no. of rows affected? For a DELETE command, Execute returns -1 in both cases, 1)when the cmd actually deleted some records, and 2) when those records didn't exist in the table.

so, it is really difficult to know if it is success.