Update Entity question (multiple records)


I now have

to update an attribute for each record in an entity (distance based on two adresses with the Google Maps API). This works, but it seems to me that there are databaseactions (trips to the db) for each record update. Is there a way to do the update for multiple records in one statement/ trip to the database ?

Regards, Harry

Hi Harry,

Only using SQL and usually only if you want to change all the records you want to change attributes to the same values.

To be able to save different values in the same fields in different records using Update is very tricky...

Eduardo Jauch

Ok Eduardo,

Thank you for the explanation. I'll stick with the solution I had.

Regards, Harry