Project OLE DB Provider

B

Brian

I have a .published file named "AIS_Employee_Mart (05-0238).published" on the
server. When I run the following query:

SELECT p.projecttitle, p.projectuniqueid, wp.wproj_id, wp.proj_name
FROM MSP_VIEW_PROJ_PROJECTS_STD p,
MSP_WEB_PROJECTS wp
WHERE p.wproj_id = wp.wproj_id
ORDER BY p.projecttitle

the value of the p.projecttitle field for the record that correlates to the
above mentioned project has the value of a different .published project with
a "_1" on the end. This is causing some errors in reporting.

Is this a known problem?

Thanks,
Brian
 
B

Brian

Thanks, Rod. I believe that's what I have. I just wrote it in Oracle's
query language which MS SQL Server, I believe, converts to the MS version
(but I could be wrong, I'm no SQL expert!). When I hit the Run button, the
query changes to:

SELECT p.ProjectTitle, p.ProjectUniqueID, wp.WPROJ_ID, wp.PROJ_NAME
FROM dbo.MSP_VIEW_PROJ_PROJECTS_STD p INNER JOIN
dbo.MSP_WEB_PROJECTS wp ON p.WPROJ_ID = wp.WPROJ_ID
ORDER BY p.ProjectTitle

I meant to add this to the original post. I named this post Project OLE DB
Provider because the Data Dictionary said that the MSP_VIEW_PROJ_PROJECTS_STD
table obtains its information from the Project table in the Project OLE DB
Provider. Is there a way to find out which Projects table this is referring
to?
 
B

Brian

OK, I think I just answered a part of my own question. The PROJECTTITLE
field on the MSP_VIEW_PROJ_PROJECTS_STD view pulls from the PROJ_PROJ_TITLE
field on the MSP_PROJECTS table. The data is also incorrect here. Is there
a reason as to why this may happen?
 
G

Gary L. Chefetz [MVP]

Brian:

Did this project begin its life through cloning? That would explain the
incorrect project title.
 
B

Brian

Thanks Gary. Forgive me, but I'm not entirely sure what cloning refers to.
Can you shed some light on that (or direct me to a source that can)?

Gary and Rod, thanks to you both for the help that you gave. This is not a
show stopper for us in any way, it's just something that struck my curiosity.
 
G

Gary L. Chefetz [MVP]

You copied another project = cloning.




Brian said:
Thanks Gary. Forgive me, but I'm not entirely sure what cloning refers
to.
Can you shed some light on that (or direct me to a source that can)?

Gary and Rod, thanks to you both for the help that you gave. This is not
a
show stopper for us in any way, it's just something that struck my
curiosity.
Click to expand...
 
Top