Number field auto increment

Money Manager Ex Development related posts
(http://github.moneymanagerex.org/)
Post Reply
edrubins
New MMEX User
Posts: 7
Joined: Thu Feb 20, 2014 1:43 am
Are you a spam bot?: No

Number field auto increment

Post by edrubins »

Version 1.3.3. On one of my accounts the number field started to auto increment to 9991. An earlier post in this forum stated that the it should auto increment to the last number used plus 1. I've looked at all of the tables in the data base to reset it, but can't find it anywhere. It's occurred to me that, given the age of the post, things may have changed. So how can I reset the last number used by an account in the database? Or is there an 'cleaner way' to do it?

Best, Ed

Nikolay
MMEX Developer
Posts: 1344
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Number field auto increment

Post by Nikolay »

I've created the following bug report:
https://github.com/moneymanagerex/money ... ssues/2379

edrubins
New MMEX User
Posts: 7
Joined: Thu Feb 20, 2014 1:43 am
Are you a spam bot?: No

Re: Number field auto increment

Post by edrubins »

Please close this issue. I realized that the highest used number was most likely found with a (sub)query on CHECKINGACCOUNT_V1:TRANSACTIONNUMBER. I updated the table to replace the errant value with the correct one and that fixed the problem.

Thank you.

Post Reply