Title: Data Designer Gotcha
Last modified: March 18, 2025

---

# Data Designer Gotcha

 *  Resolved [PatJ](https://wordpress.org/support/users/patj/)
 * (@patj)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/data-designer-gotcha/)
 * 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](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/data-designer-gotcha/#post-18367187)
 * Hi [@patj](https://wordpress.org/support/users/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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [1 year, 2 months ago](https://wordpress.org/support/topic/data-designer-gotcha/#post-18367187)
 * Status: resolved