QUESTION:.
How can you change the name of a project in the database?
ANSWER:
The responsibility for changes made in the project database always lies in the hands of the user.
In any case you must always create a back-up of the project database (<Project name>.DB) before proceeding as described below:
- Start the application "Scview.exe". This application is usually located in the Siemens\Common\sqlany path.
- Log into the database under the menu item "TOOLS CONNECT".
|
|
ID: |
dba |
|
|
Login: |
sql |
|
|
Server name: |
Computer name |
|
|
Database name |
Project name.db |
|
|
Database file: |
Use the browser here to find the relevant database file |
- If the link to the database is successful, select the "Tables" item in the database explorer.
Now all the tables in the database are displayed. You need the table "MCPTPROJECT".
- Open the relevant table using "View data". Now a "DATA", a "STATISTICS" and a "COMMAND" window are opened.
- The "Command" window already displays the line "SELECT * FROM "DBA"."MCPTPROJECT".
Terminate this line with a semicolon and enter the following command line:
SELECT * FROM MCPTPROJECT
<EXECUTE>
UPDATE MCPTPROJECT SET PROJECTNAME = '<New name>'
<EXECUTE>
If you are not quite familiar with the SQL database, read the Help file in the database.
The Help file also offers useful information on other operations, changes and procedures.
| 
german
