I am interested in using Valentina Server as a SQLite DB server with client access using REST API. I'm running VServer 7.1.3 and my client access is a Excel 2010 VBA program. HTTP calls are made using the MSXML2.XMLHTTP60 object from Microsoft XML Core Services (Microsoft XML v6.0). I have managed to get the HTTP requests to work (open session, execute SELECT queries, etc).
When I try to UPDATE or DELETE a row from the SQLite database, the number of AffectedRows returned is always zero (whether successful or not). However, executing an INSERT will return the total number of rows in the database (including the newly inserted row) in the AffectedRows count.
Is there any way for me to obtain the number of rows modified by a successful UPDATE or DELETE statement? I've tried calling the SQL Changes() function but can't get it to work either. BTW, I'm not using any triggers in my SQLite DB which I understand might complicate the issue.