key variables--interpretation

[lszyrmer]

Hi all,

I'm in the process of developing a series of macros in Excel, pulling data
from PS using ActiveX SQL queries, and I've come across a few key values in
the database, but I'm exactly sure how to interpret them, based on the
existing values in the database.

Specifically,
MSP_WEB_WORK.WWORK_UPDATE_STATUS
MSP_WEB_PROJECTS.wwork_approval_status
MSP_WEB_ASSIGNMENTS.WASSN_ACTUALS_PENDING

While I can guess at the the first two since they use 0 and 1, I'm finding
that the last one sometimes contains a value of 2. Does anyone know in more
detail exactly what each value 0,1 and 2 in each case means, and also what
they might mean when used together? Is there a source online or elsewhere
that I am missing?

 

[Dale Howard [MVP]]

lszyrmer --

I would recommend you post this question in the
microsoft.public.project.developer newsgroup, as you are more likely to get
a response there. Hope this helps.