|
|
| Reporter | Kevin Yan | Assigned To | Ivan Smahin | |
|---|
| Priority | normal | Severity | minor | Reproducibility | always |
|---|
| Status | resolved | Resolution | fixed | |
|---|
| Platform | INTEL | OS | Windows | OS Version | * |
|---|
| Target Version | 7.1.x | Fixed in Version | 7.1.x | |
|---|
|
|
| Summary | 0007969: Number of AffectedRows returned is always zero on SQL UPDATE and DELETE on a SQLite DB using REST API |
|---|
| Description | When 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 Information | Running 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). |
|---|
| Tags | No tags attached. |
|---|
|
|
