Massive update refused
Hello, I created a field 'Name2' to reformat the field 'Name', in uppercase. The idea is to have "John" in 'Name2' while I have "JOHN" in 'Name'.
My code is :Name2 := upper(substr(Name, 0, 1)) + lower(substr(Name, 1, length(Name) - 1))
When pasted in the 'calculates value' of 'Name2' in massive update, I receive the message : "This formula cannot modify the data." (I get this message in French, so my translation may be approximative.)
Any idea ?
2 replies
-
Alain,
You better make a button or use the console for this. Afterwards you can delete the button again.
Formula should be something like this:
---
for i in select Yourtable do
i.Name2 := capitalize(lower(Name))
end
---
Note: Take a BACKUP before trying !
Steven.
-
Steven,
You solved my problem. Thanks a lot!
Alain
Content aside
- 4 yrs agoLast active
- 2Replies
- 631Views