View Issue Details

IDProjectCategoryView StatusLast Update
0007969VALENTINA SERVERREST APIpublic2017-05-17 09:32
ReporterKevin YanAssigned ToIvan Smahin 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSWindowsOS Version*
Product Version 
Target Version7.1.xFixed in Version7.1.x 
Summary0007969: Number of AffectedRows returned is always zero on SQL UPDATE and DELETE on a SQLite DB using REST API
DescriptionWhen a SQL UPDATE or DELETE statement is executed on a SQLite DB using REST API, the number of AffectedRows returned is always zero (whether successful or not). However, executing an SQL INSERT will return the total number of rows in the database (including the newly inserted row) in the AffectedRows count.
Additional InformationRunning Valentina Server as a SQLite DB server with client access using REST API. VServer is version 7.1.3 and 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).
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-05-16 09:05 Kevin Yan New Issue
2017-05-17 09:32 Ivan Smahin Target Version => 7.1.x
2017-05-17 09:32 Ivan Smahin Status new => resolved
2017-05-17 09:32 Ivan Smahin Fixed in Version => 7.1.x
2017-05-17 09:32 Ivan Smahin Resolution open => fixed
2017-05-17 09:32 Ivan Smahin Assigned To => Ivan Smahin