Corrupted database in P2K

[Robert J.M. Edis]

G'day all

While I believe Power2000 to be a powerful and useful tool, it can be a very
annoying one!

I tried to create an assignment but the process failed and P2K told me no
programs were assigned.  I tried a second time and was successful.  The
programmer did his work and returned the assignment to me.

I then tried to 'receive' the assignment in the main project database but
got a programid error and the message that NO files were received.  It lied.
I tried this several times and got the same message each time.  Eventually I
'received' each of the 100 or so programs one by one.  In most cases P2K
told me the program had already been received even though the flags in the
database show it as assigned (based on received date I think).

One program remains shown as assigned to the programmer but it is not in the
assignment database.

So now my situation is this:  I have a bunch of issue_programs records with
a missing received date and time and one record showing as assigned but it
isn't.

How can I fix the database records to 
A)	insert the correct received date and time?
B)	B) remove all references to the one program shown as assigned (it
turned out to be obsolete anyway)?

Can I use Axiant?

Blue
PowerHouse consultant
Rhode Island, USA

Disclaimer:
The opinions and ideas expressed in this message are my own and have no
relationship to my current employer, Initial Technical Staffing, its client
CCI, or any of CCI's clients.


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.