[Moneymanagerex-commits] SF.net SVN: moneymanagerex:[2462] trunk/mmex

[<gua...@us...>]

Revision: 2462
          http://moneymanagerex.svn.sourceforge.net/moneymanagerex/?rev=2462&view=rev
Author:   guanlisheng
Date:     2012-05-30 06:03:46 +0000 (Wed, 30 May 2012)
Log Message:
-----------
change REPEATS from numeric/double to integer/int

Modified Paths:
--------------
    trunk/mmex/sql/tables_v1.sql
    trunk/mmex/src/mmex_db_view.h

Modified: trunk/mmex/sql/tables_v1.sql
===================================================================
--- trunk/mmex/sql/tables_v1.sql	2012-05-30 03:39:15 UTC (rev 2461)
+++ trunk/mmex/sql/tables_v1.sql	2012-05-30 06:03:46 UTC (rev 2462)
@@ -44,7 +44,7 @@
 , TRANSDATE TEXT
 , FOLLOWUPID integer
 , TOTRANSAMOUNT numeric
-, REPEATS numeric
+, REPEATS integer
 , NEXTOCCURRENCEDATE TEXT
 , NUMOCCURRENCES numeric
 );

Modified: trunk/mmex/src/mmex_db_view.h
===================================================================
--- trunk/mmex/src/mmex_db_view.h	2012-05-30 03:39:15 UTC (rev 2461)
+++ trunk/mmex/src/mmex_db_view.h	2012-05-30 06:03:46 UTC (rev 2462)
@@ -10,7 +10,7 @@
  *      @brief
  *
  *      Revision History:
- *          AUTO GENERATED at 2012-05-20 17:20:38.055000.
+ *          AUTO GENERATED at 2012-05-30 14:02:07.298737.
  *          DO NOT EDIT!
  */
 //=============================================================================
@@ -976,7 +976,7 @@
 
         try
         {
-            db->ExecuteUpdate(wxT("CREATE TABLE BILLSDEPOSITS_V1(BDID integer primary key, ACCOUNTID integer NOT NULL, TOACCOUNTID integer, PAYEEID integer NOT NULL, TRANSCODE TEXT NOT NULL, TRANSAMOUNT numeric NOT NULL, STATUS TEXT, TRANSACTIONNUMBER TEXT, NOTES TEXT, CATEGID integer, SUBCATEGID integer, TRANSDATE TEXT, FOLLOWUPID integer, TOTRANSAMOUNT numeric, REPEATS numeric, NEXTOCCURRENCEDATE TEXT, NUMOCCURRENCES numeric)"));
+            db->ExecuteUpdate(wxT("CREATE TABLE BILLSDEPOSITS_V1(BDID integer primary key, ACCOUNTID integer NOT NULL, TOACCOUNTID integer, PAYEEID integer NOT NULL, TRANSCODE TEXT NOT NULL, TRANSAMOUNT numeric NOT NULL, STATUS TEXT, TRANSACTIONNUMBER TEXT, NOTES TEXT, CATEGID integer, SUBCATEGID integer, TRANSDATE TEXT, FOLLOWUPID integer, TOTRANSAMOUNT numeric, REPEATS integer, NEXTOCCURRENCEDATE TEXT, NUMOCCURRENCES numeric)"));
         }
         catch(const wxSQLite3Exception &e) 
         { 
@@ -1117,7 +1117,7 @@
         wxString TRANSDATE;
         int FOLLOWUPID;
         double TOTRANSAMOUNT;
-        double REPEATS;
+        int REPEATS;
         wxString NEXTOCCURRENCEDATE;
         double NUMOCCURRENCES;
         int id() const { return BDID; }
@@ -1136,7 +1136,7 @@
             SUBCATEGID = -1;
             FOLLOWUPID = -1;
             TOTRANSAMOUNT = 0.0;
-            REPEATS = 0.0;
+            REPEATS = -1;
             NUMOCCURRENCES = 0.0;
         }
 
@@ -1158,7 +1158,7 @@
             TRANSDATE = q.GetString(wxT("TRANSDATE"));
             FOLLOWUPID = q.GetInt(wxT("FOLLOWUPID"));
             TOTRANSAMOUNT = q.GetDouble(wxT("TOTRANSAMOUNT"));
-            REPEATS = q.GetDouble(wxT("REPEATS"));
+            REPEATS = q.GetInt(wxT("REPEATS"));
             NEXTOCCURRENCEDATE = q.GetString(wxT("NEXTOCCURRENCEDATE"));
             NUMOCCURRENCES = q.GetDouble(wxT("NUMOCCURRENCES"));
         }

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.