M
Magnus S
We have a project that has been deleted from the datrabase using the
PSCleaner utility
When we now try to import a project with the same old name we get a problem
and when I check the SQL then the problem is with the question
SELECT
P.PROJ_ID,P.PROJ_NAME,P.PROJ_TYPE,P.PROJ_PROJECT,P.PROJ_VERSION,P.PROJ_LAST_SAVED,
P.PROJ_CHECKEDOUT,P.PROJ_CHECKOUTBY,P.PROJ_CHECKOUTDATE,P.PROJ_ADMINPROJECT,
WP.WPROJ_ID
FROM MSP_PROJECTS P LEFT JOIN MSP_WEB_PROJECTS WP ON P.PROJ_ID = WP.PROJ_ID
WHERE lower(P.PROJ_NAME) = lower('South Africa xxx.Published')
It looks like table MSP_PROJECTS still contain an item 'South Africa
xxx.Published'
Question How to delete it or rename it
PSCleaner utility
When we now try to import a project with the same old name we get a problem
and when I check the SQL then the problem is with the question
SELECT
P.PROJ_ID,P.PROJ_NAME,P.PROJ_TYPE,P.PROJ_PROJECT,P.PROJ_VERSION,P.PROJ_LAST_SAVED,
P.PROJ_CHECKEDOUT,P.PROJ_CHECKOUTBY,P.PROJ_CHECKOUTDATE,P.PROJ_ADMINPROJECT,
WP.WPROJ_ID
FROM MSP_PROJECTS P LEFT JOIN MSP_WEB_PROJECTS WP ON P.PROJ_ID = WP.PROJ_ID
WHERE lower(P.PROJ_NAME) = lower('South Africa xxx.Published')
It looks like table MSP_PROJECTS still contain an item 'South Africa
xxx.Published'
Question How to delete it or rename it