hello geoff,
please look at this video, this behaviour is still there.
the messagebox did not show the edit value before.
https://youtu.be/B8-zk53DAvc
seems the data was saved into database but the object still have old values.
and my additional feedback in this ticket was ignored.
What happens if you do another query to show the changes? It seems you are using the old query to show the values again…
its oop, i change the object, the object update the database.
its possible that you need the object later in a method or window.
it should look like
For Each row As DatabaseRow In rows
If row.Column("id").IntegerValue = 1 Then
row.EditRow
row.Column("Test").Value = "Geoff"
row.SaveRow
End If
Next
not
For Each row As DatabaseRow In rows
If row.Column("id").IntegerValue = 1 Then
rows.EditRow
rows.Column("Test").Value = "Geoff"
rows.SaveRow
End If
Next
but DatabaseRow have no EditRow & SaveRow method.
with a new query i guess the data in rowset are the same as database.
You don’t need to tell how it’s suppose to be done… I’m just asking what the result is. In case it might help, please don’t guess but evaluate the actual result and report it in a FB case. They can’t seem to reproduce but it looks like you can…
ok i can do later. i expect that what appear in database appear in new query too.
They can’t seem to reproduce but it looks like you can…
i tested it with window 10
I’ll try this on Windows but I can’t reproduce it on MacOS.
1 Like
I tried it on Windows and I can’t reproduce it. What version of Xojo are you using? I’m trying to figure out what is different about your setup versus mine.
2 Likes
because your testing staff was unable to reproduce the behavior. (Xojo 2020r1.2)
i installed also Xojo 2020r1.2 this morning.
my pc use a german enviroment,
maybe the reason why i have other side effects and your team newer saw or tested this.
It’s hard to imagine that it would be due to the OS being set to German but I suppose that is possible.
2 Likes
i think for this behavior you need to flollow the source code to understand what’s doing.
are there exceptions that skipped or logged and not viewed?