On Wed, 19 Oct 2011, Armaghan Saqib wrote:
Due to many reasons, referential integrity in SQL-Ledger (and Ledger123) is maintained by the application and not by database. So if you delete any parent rows (from ar,ap,gl) directly from database, respective rows are not deleted from acc_trans. (So be very careful when doing this)
Armaghan, I have neither the skills, interest, or time to assist in developing L123 so the reasons referential integrity is not left to the database don't need to be explained or justified. It seems to me, however, that there's more work, complexity, and potential for errors maintaining RI in the middleware when the back end is so capable of handing it. Well, at least postgres and sqlite are (the latter with triggers but this may have changed). Thanks for the explanation, Rich _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
