Do you have "enforce transaction reversal" selected under defaults?
It sounds like you haven't quite figured out your ultimate workflow yet.
If that's the case, setting that to "no" will let you delete things more
easily (I.D. without manually altering database contents), which seems to
be something you need.
On Mon, 14 Feb 2011, Rich Shepard wrote:
On Mon, 14 Feb 2011, Rich Shepard wrote:
update jcitems set allocated is null where id = 87;
Nope: update jcitems set allocated = 0 where id = <whatever>;
Is there any other cleaning I need to do on this in other tables?
This still needs answering.
Rich
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
