1. Kevin Yan
  2. as SQLite DB Server
  3. Dienstag, Mai 16 2017, 08:34 AM
  4.  Abonnieren via E-Mail
Hi,

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.

Thanks.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi,

Could you report it to the Mantis?
Meanwhile, I will check it.
Kommentar
There are no comments made yet.
Kevin Yan Akzeptierte Antwort
OK, I will make a report to Mantis. Thanks for your quick reply.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.