diff src/main.cpp @ 113:907f2ddf6801

Use #defines for SQL table field lengths.
author Matti Hamalainen <ccr@tnsp.org>
date Wed, 05 Jul 2017 09:52:10 +0300
parents 2524434a7193
children a5c8741b8662
line wrap: on
line diff
--- a/src/main.cpp	Tue Jul 04 12:43:43 2017 +0300
+++ b/src/main.cpp	Wed Jul 05 09:52:10 2017 +0300
@@ -218,11 +218,14 @@
     {
         query.exec(QStringLiteral(
             "CREATE TABLE people (id INTEGER PRIMARY KEY, "
-            "first_name VARCHAR(128) NOT NULL, "
-            "last_name VARCHAR(128) NOT NULL, "
-            "extra_info VARCHAR(2048), "
+            "first_name VARCHAR(%1) NOT NULL, "
+            "last_name VARCHAR(%2) NOT NULL, "
+            "extra_info VARCHAR(%3), "
             "added DATETIME NOT NULL, "
-            "updated DATETIME NOT NULL)"));
+            "updated DATETIME NOT NULL)").
+            arg(SQL_MAX_FIRST_NAME).
+            arg(SQL_MAX_LAST_NAME).
+            arg(SQL_MAX_EXTRA_INFO));
 
         slCheckAndReportSQLError("CREATE TABLE people", query.lastError());
     }
@@ -855,6 +858,9 @@
     ui->tableview_Transactions->verticalHeader()->setVisible(false);
     ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
 
+    ui->edit_FirstName->setMaxLength(SQL_MAX_FIRST_NAME);
+    ui->edit_LastName->setMaxLength(SQL_MAX_LAST_NAME);
+
     validateForm();
 }