1. Kevin Yan
  2. as SQLite DB Server
  3. 火, 5月 16 2017, 08:34 AM
  4.  メールで購読
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.
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
Hi,

Could you report it to the Mantis?
Meanwhile, I will check it.
コメント
There are no comments made yet.
Kevin Yan 承諾済みの回答
OK, I will make a report to Mantis. Thanks for your quick reply.
コメント
There are no comments made yet.
  • ページ :
  • 1


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