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

Reply via email to