On Fri, 11 Jun 2010, Rich Shepard wrote:
There must be a field in one of the postgres tables that changes each individual time card row to 'closed.' Doing so manually from the psql interface is fine with me as long as I know what table is involved. Then it's a matter of 'UPDATE <table> SET <status_column> = 'closed' where <timecard_number_column> in (<list of timecards>;'.
Armaghan provided the exact syntax: UPDATE jcitems SET allocated = qty WHERE id IN (1,2,3,4...etc.); Works like a charm! I thought the jcitmes table was where those data are stored, but didn't pick up that the 'allocated' column reflected the timecard being open or closed. Thanks Armaghan! Rich _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
