On Fri, 11 Jun 2010, Paul Tammes wrote:

Workaround hint:

Do not touch the old project X and open a new project X-2010 or even
X-2010-06

Paul,

  I don't think that would work. The project is the same; we had to
determine if the plaintiff would settle or the judge would issue a summary
judgement for the defense. No and no, so we go to trial and I have to
prepare my expert witness testimony. Same project.

  Why the February time cards were not closed when I prepared that month's
statement I've no idea. Probably because the entire process of preparing a
statement of time expended against a received retainer payment is still not
completely clear to me.

  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>;'.

Rich

_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger

Reply via email to