1. Kevin Yan
  2. as SQLite DB Server
  3. Вторник, Май 16 2017, 08:34 AM
  4.  Подписаться через 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.
Комментарий
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.

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