Hi, many thanks for your great work.
If you use the dialog to alter a column in a sql server table and try to set the default value to '' then the following error message occured:
[Window Title]
MsSQL-Test: Fehler
[Content]
SQL Fehler (156): Incorrect syntax near the keyword.
[OK]
[Footer]
Google Suche nach diesem Fehler
Perhaps you use the same Sql-Command generator for mysql and mssql. On Stackoverflow I found this snippet:
ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}
[WITH VALUES]
Perhaps this will solve the issue?
Regards, Spotlight