But in client/server mode, this command update *all fields* of all records of the cursor.
Using Xojo 2019r1.1, MacOS 10.14.6, Valentina v9.8.2
To reproduce,
1) Create a Cursor with several fields and several records
2) Assign a new value to only one field
3) Do Cursor.UpdateAllRecords
In standalone mode, all records has now the same value for the updated field only
=> ok
In client/server mode, all records has now the same values for *all fields*
=> very bad
My code is
Dim myCursor As VCursor
Dim sql As String
Dim fld1 As Field
sql = "SELECT myfieldName1, myFieldName2, myFieldName3 FROM myTableName"
myCursor = myDatabase.SQLSelect(sql, EVCursorLocation.kServerSide, EVLockType.kNoLocks, EVCursorDirection.kRandom)
myCursor.Field(1).SetString(someNewValue)
myCursor.UpdateAllRecords
// => All records have the value of the first record for myfieldName1, myFieldName2, myFieldName3
Do I something wrong ?
I will report this bug in Mantis.
1) Which section should I choose : Valentina Server, VComponent-VClient or VComponent-Server ?
2) Which category should I choose : API, Cursor Server-side, Fields, ... ?