If you think that something doesn't work in Aware IM post your message here
#51236 by jannes
Thu Jul 25, 2019 2:18 pm
Table with 2 fields :
Name : Plain text
Period : Number

I want to update (increase) field “period” by 1
In SQL : UPDATE person SET period = period + 1 WHERE period > 2017

I expect :
FIND Persoon WHERE Persoon.Period > 2017
Persoon.Period=Persoon.Period + 1

But this doesn’t work properly, all selected records are updated to the same value.

So I used an extra : IN BATCHES OF 1
FIND Persoon WHERE Persoon.Periode > 2017 IN BATCHES OF 1
Persoon.Periode=Persoon.Periode + 1

It worked but I guess it will be very slow when there are many records.
#51239 by eagles9999
Fri Jul 26, 2019 12:59 am
Have sent you a sample bsv on Skype Jannes

Who is online

Users browsing this forum: No registered users and 13 guests