Re: About GnuCash 2.3.x / 2.4

2009-08-20 Thread Colin Law
2009/8/4 Phil Longstaff : > [snip] > > The balance for account 'ABC' on date 'D' can be determined by: > > SELECT SUM(amount_num),amount_denom FROM splits WHERE tx_guid IN (SELECT * > FROM transactions WHERE post_date <= D) AND account_guid = (SELECT guid FROM > accounts WHERE name = 'ABC') GROU

Re: About GnuCash 2.3.x / 2.4

2009-08-05 Thread AmigaPhil
Phil Longstaff wrote: > [...] Thanks for this indeep info. > There is *ABSOLUTELY NO GUARANTEE* of what will happen if you try to modify > the data using anything other than gnucash. Sure. Accessing/updating a GnuCash "file" in such a low level way can be even more dangerous than modifying a

Re: About GnuCash 2.3.x / 2.4

2009-08-04 Thread Phil Longstaff
happen if you try to modify the data using anything other than gnucash. At some point, this information will be put into the gnucash development wiki. Phil ____________________ From: AmigaPhil To: gnucash-u...@gnucash.org Sent: Tuesday, August 4, 2009 4:49:02 PM Subject: About