1. François Van Lerberghe
  2. Valentina Server
  3. Samstag, Februar 15 2020, 07:24 AM
  4.  Abonnieren via E-Mail
In standalone mode, VCursor.UpdateAllRecords update only "dirty" fields of all records of a cursor, as expected (and described in the Wiki).
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, ... ?
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
I guess it would be better - Valentina Server and Cursor Server-side. Thank you for report.
Kommentar
There are no comments made yet.
  • Seite :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories