Re: [GNC] how to commit a transaction with sqlite

2022-11-09 Thread David Cousens
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 +, 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@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.

___
gnucash-user mailing list
gnucash-user@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.


[GNC] how to commit a transaction with sqlite

2022-11-09 Thread Jim McNamara via gnucash-user
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@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.