SQL backend for GnuCash 2
Phil Longstaff
plongstaff at rogers.com
Fri Oct 27 12:19:00 EDT 2006
On Fri, 2006-27-10 at 11:58 -0400, Derek Atkins wrote:
> I'm not sure what you mean by "cascade of DELETE operations".
> I think we CAN depend on the DB supporting transactions, but it
> might depend on what level of TXN support we want/need.
With foreign keys, you can specify what should happen if a row in
another table is changed when the first table refers to the second one.
For example, we could set it up that since a transaction split refers to
the account it is in (foreign key), if an account is deleted, all splits
referring to that account are also deleted. Or, if the account GUID is
changed, all splits referring to that account will have the foreign key
GUID changed.
Phil
More information about the gnucash-devel
mailing list