1. Kevin Yan
  2. as SQLite DB Server
  3. Tuesday, May 16 2017, 08:34 AM
  4.  Subscribe via email
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.
Comment
There are no comments made yet.
Kevin Yan Accepted Answer
OK, I will make a report to Mantis. Thanks for your quick reply.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
Ivan Smahin Accepted Answer
Hi,

Could you report it to the Mantis?
Meanwhile, I will check it.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 2
  • Page :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories