[GNC] how to commit a transaction with sqlite

David Cousens davidcousens49 at gmail.com
Wed Nov 9 21:42:41 EST 2022


Jim,

The transaction should be committed to the datafile immediately on pressing
"Enter" in any transaction editing mode in an account register using any of the
database backends. You normally use the 'Tab key to cycle through fields in the
transaction as you do in the xml backend. AFAIK Enter in the xml backend only
commits the transaction to a copy in memory but not to the file on disk. 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html
https://wiki.gnucash.org/wiki/SQL

David Cousens

On Thu, 2022-11-10 at 02:11 +0000, Jim McNamara via gnucash-user wrote:
> Hi-
> The save button by design doesn't work with sqlite. How can I "commit" the
> transaction in sqlite when moving from current transaction or all transactions
> from a screen?
> I tried to install sqlite. I changed from xml to sqlite and my file had a
> .gnucash ending.
> I used libdbsqilte3 from the package manager.
> My version I am running is Version: 4.8Build ID: 4.8a+(2021-09-28)
> Linux O/S
> Thanks for any tips you can provide.
> Thanks
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list