On Wed, Oct 19, 2011 at 1:09 AM, Rolf Stöckli <[email protected]> wrote: > Am 19.10.2011 01:48, schrieb Chris Travers: >> >> One note: >> You can't use rules instead of triggers. We learned this the hard way >> in 1.2 :-) > > Can you explain in a few words what you tried to do there? > we used CREATE RULE.... DO ALSO... in 1.2. Don't do that. It calls nextval() once for the insert to ar, ap, or gl, and then once for the insert into transactions..... This means the two values don't match which defeats the purpose.
Best Wishes, Chris Travers _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
