Different behaviour of a formula in a batch update environment
I need to add a picture to the IMAGE field of each record of my database, starting from the relevant URL_PICTURE address.
I don't understand why the following formula works perfectly when used in a button, but fails when used in a batch update:
IMAGE := importFile(this, URL_PICTURE)
The message error I get is: "This formula may not modify data"
What am I missing?
2 replies
-
Where do you try the 'batch' update?
If you do it in a button or in the console you can try like this: (once done, you can delete the button)
for i in select Table1 do
i.(IMAGE := importFile(i,i.URL_PICTURE))
endSteven
-
Tks Steven, it worked perfectly.
Nevertheless, I would prefer working inside the "Table/Update Multiple Records...." which allows a safer filtering and a preview before committing.
Is it really impossible?
Content aside
- 3 yrs agoLast active
- 2Replies
- 279Views