Page 1 of 1

Number field auto increment

Posted: Wed Apr 08, 2020 12:01 am
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

Re: Number field auto increment

Posted: Sun Apr 12, 2020 11:42 am
by Nikolay
I've created the following bug report:
https://github.com/moneymanagerex/money ... ssues/2379

Re: Number field auto increment

Posted: Sun Apr 12, 2020 12:02 pm
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.