Which field is 188743700?

[Kamil Dursun]

Hi,

I am trying to do some event programming.

I want to capture the event when I drag the % complete field on a Gantt
chart. When the event occurs, I know that the field that was changed is the
field number 188743700.

Where do I find a table of fields and their integer equivalents?

Thanks
Kamil

 

[JackD]

MSP_CONVERSIONS has this data.

 

[Kamil Dursun]

Thank you Jack,

Can you also tell me how to find this table? It seems to be difficult to get
the information out of it (SQL queries and all that).

Appreciate some help for a beginner.

Thanks
Kamil

 

[JackD]

It is described in the projdb.htm documentation.
You can get the information out of the table by running a simple sql query

SELECT * FROM MSP_CONVERSIONS

That will give you a dump of everything in the table. Then by looking at
Projdb.htm you can make sense of it.
If you want to work with the database, I'd recommend that you get some basic
instruction in SQL. Having some idea on how to do basic queries, how to
backup a database and how a database is designed will help you if you are
doing development or administering project server.

projdb.htm is on your project cd or any computer with Project installed.