0

Changing field type

Is is possible to change field type once the field has been defined ? In this case I need to go from Text to Numeric ?

3 replies

null
    • Sean
    • 6 yrs ago
    • Reported - view

    I think you have to create a Number field and copy the values from the Text field to the Number field. You can add a Button with this formula:

     

    for f in select Table1 do
    f.(Number := f.Text)
    end

     

    Then delete the Text field and Button when done.

    • Mconneen
    • 6 yrs ago
    • Reported - view

    You can also use the Console..   and if you are not 100% certain all the fields have valid numbers... add an alert..

    console

    • Marek
    • 6 yrs ago
    • Reported - view

    Thank you for your prompt and kind help

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 2300Views