Navigation

    APPDRAG Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular

    REMINDER

    Please be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.

    Bug: Updating company columns when time field exists

    Cloud Backend (Cloud DB, API Builder)
    1
    1
    263
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Daniel Mulroy
      Daniel Mulroy last edited by

      Hello team,

      Bug:
      When adding a column to a table with a time field that has an existing default value, the alteration fails.

      Expected behavior:
      It should work 🙂

      Problem:
      When rendering the default value for the time field, the number is formatted for humans. I.e. 110000 becomes 11:00:00 in the UI.

      However, when altering the table, your code is performing an UPDATE query that tries to set 11:00:00 as the default value for a TIME type column, which fails.

      Workaround:
      Manually editing 11:00:00 to 110000 before saving your changes to the table causes the update to succeed.

      @Joseph-Benguira

      1 Reply Last reply Reply Quote 0
      • First post
        Last post