Deleting a RequisitePro project from an enterprise database

Resolving The Problem

This process details how to remove both Enterprise and Microsoft® Access projects. These steps entail three portions:

• Removal of the project from the database
• Deletion of the corresponding project files on the file system
• Removal of the project from the RequisitePro project list

Microsoft Access:

To remove a RequisitePro project from a Microsoft Access database use these steps:
Note: Due to the fact that Access projects are a one to one relationship with a given project and database, the deletion of the project is simple. An Access based RequisitePro project is simply stored in a file with the name of the project.mdb.

1. Find the location of the project by selecting the File > Open Project.
2. Select the project in the list, and the path to the project will be displayed.
3. Navigate to this location through Microsoft Windows® Explorer.
4. The project should be placed in a directory with the same name as the project.
5. Within this directory, there will be three files with the project name. These files include project.mdb, project.rqs, and project.rql. (The .rql file is a hidden file, and all files must be displayed in order to see this file.) There may also be RequisitePro documents in this directory. These documents may also be deleted.
6. Deletion of Database, simply highlight the project.mdb file and select delete.

Oracle:

To remove a RequisitePro project from an Oracle database use these steps:
1. Log into SQL*Plus as the ReqPro user.
2. List all the RequisitePro projects in an Oracle database by executing the following command:
   
Select id,name from RqProjects;

3. Identify the project id for the project you want to delete.
4. Execute the following statement to remove the RequisitePro project from the Oracle database. Replace the value 1 with the id of the project you want to delete. A message displays to confirm that the project is deleted.
   
Execute RqDelete_project (1);

   

To remove a RequisitePro project from a Microsoft SQL Server database use these steps:
1. Log in to SQL Query Analyzer as the ReqPro user.
2. Execute the following command to list all the RequisitePro projects in a SQL Server database:
   
Select id,name from RqProjects;

3. Find the project id for the project you want to delete.
4. Execute the following statement to remove the RequisitePro project from the SQL Server database. Replace the value 1 with the id of the project you want to delete. A message displays to confirm that the project is deleted.
   
Exec RqDelete_project 1;

   

To remove a RequisitePro project from a IBM DB2® database use these steps:
1. Access the Command Center and connect to your db2 database as the ReqPro user
2. Run the following stored procedure, where projectid is the ID of the database you want to delete:
   
call rqdelete_project(projectid)

3. This should delete the project from DB2 database completely, you have to remove project folder as well.

In order to delete the .rqs, .rql, and document files, simply select the files and select delete in Windows Explorer.

Removal of Project From Project List

1. Open RequisitePro, and select the File > Open Project command.
2. This action will list all of the projects in the user's project list.
3. A registry reference on the local PC is created for each project in the project list.
4. In order to remove this registry reference, highlight the project in the project list and select Remove.