Firebird needs DEFAULT before NOT NULL
Brought to you by:
fabianbecker,
jpss
Exporting into a Firebird format places DEFAULT values after the NOT NULL declaration but this is backwards. This patch modifies the default value for this option in a Firebird export configuration.
--- EERExportSQLScript.pas (revision 22)
+++ EERExportSQLScript.pas (working copy)
@@ -689,7 +689,7 @@
HideOnDeleteUpdateNoActionCBox.Checked := false;
GOCB.Checked := false;
CommitCB.Checked := false;
- CBDefaultBeforeNotNull.Checked := false;
+ CBDefaultBeforeNotNull.Checked := true;
// CBAutoIncrement.Checked := true;
CBAutoIncrement.Enabled := true;