When use_sql_quoted_identifiers=true, Tersus will refer to schema (table,column,etc.) names as-is without trying to sqlize the name, which means that if a space character appears in the name in the model, Tersus will not convert it to underscore for database access.
If I understand your description, then I'd guess you're depending on Tersus' init_db=true functionality to auto-create missing tables/columns, so if your application was originally set to use_sql_quoted_identifiers=false (which is the default), columns were automatically created sqlized.Once the same application was switched to use_sql_quoted_identifiers=true and restarted then the auto-create mechanism would not longer find the columns it created previously, and would add new (non-sqlized) columns.
You'll need to fix your database, using the tools provided by the database, removing the unwanted (auto-created) columns, before continuing your work, and in the future you might want to consider stopping auto-creation of columns, and start creating the columns (as well as other database schema) using the tools provided by the database you're using - that's what we always do in larger applications and production environments.
Regards,
David
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
