Data Designer Gotcha

  • Resolved PatJ

    (@patj)


    1 year, 2 months ago

    In the new data designer a table structure is presented for edit if you select alter table. However the catch for anyone not confident in SQL is that default values are shown in doubled single quotes instead of just single quotes (for varchar) or no quotes (for numbers) so ”0” instead of ‘0’ for a varchar and ”0” instead of 0 for integer fields. Even if you are not intending to alter the default value, you still have to correct those doubled quotes before the table will alter successfully.

Viewing 1 replies (of 1 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year, 2 months ago

    Hi @patj,

    Thanks for letting us know!

    I’ll forward this observation to Peter so that he can take a closer look.

    We appreciate your contribution to the plugin! 🙏

    Let us know if you have other feedback or questions.

Viewing 1 replies (of 1 total)

The topic ‘Data Designer Gotcha’ is closed to new replies.