1

Move value of field to a new field for entire table

Hello, I need to copy the value of one field to a new field in the same table but I need to do this for all the records in the table. I know I can do it for one specific record at a time but what would the code be if I want to do this move for the entire table with the click of a button?

1 reply

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    You could use someting like this in a button:

    for i in (select yourtablename) do
    i.newfield := i.oldfield
    end

    Make sure to make a backup first.

    Steven

Login to reply

Content aside

  • 1 Likes
  • 4 yrs agoLast active
  • 1Replies
  • 623Views