[GNC] Database Manipulation

[John Ralls]

No. It is not safe to make any changes to the database while GnuCash is connected to it because GnuCash reads the database only at the start of the session and only writes after that. If you remove objects from the database you should be careful to clean up all of the references to them as well--and of course that will be recursive. Note that GnuCash doesn't set any relations in the database so you won't be able to use the usual referential integrity tools.

Regards,
John Ralls

> On Jul 18, 2020, at 2:47 PM, Jon Griffith <jon at jongriffith.com> wrote:
> 
> If I'm in the middle of creating an invoice, prior to that invoice being
> posted, is it safe to delete the associated line items from `entries` and
> `invoices` directly from MySQL in order to remove it altogether?
> 
> 
> 
> 
> -- 
> [image: photo]
> *Jon Griffith*
> REALTOR®, HomeSmart
> 
> 480-463-4062 | jon at jongriffith.com
> 
> http://realtor.jongriffith.com
> 10601 N. Hayden Road, Suite I-100 | @RealScottsdale
> <http://facebook.com/realscottsdaleliving>
> <http://twitter.com/realscottsdale>
> <http://www.youtube.com/realscottsdaleliving>
> <http://www.linkedin.com/in/jonathangriffith>
> Get your own email signature
> <https://www.wisestamp.com/signature-in-email?utm_source=promotion&utm_medium=signature&utm_campaign=get_your_own&srcid=4578964714553344>
> _______________________________________________
> 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
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.