Problem importing a project get a name conflict with deleted item

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top