2. PHPRunner General questions
  3. [SOLVED]  Rename the original DB object
This topic is locked
[SOLVED]

 Rename the original DB object

 		2/20/2015 10:30:42 AM
PHPRunner General questions
B
 bcritchley author

I have just started to use PHP Runner and have a simple question. I went through and created a simple project connected to an SQL database called Request_Form_1. Upon finalizing my design and liking what I had, I noticed the link created to the add page was dbo_request_form_1_add.php I would like to make this a bit more user friendly but I am not certain how to do this? I would like my URL link to end up as Request.php ideally, or Request_add.php

Thank you in advance for any suggestions.
P
 		procheck 2/21/2015

Hi,

Clone your database to the new name using PHPMyadmin (Search Google for phpmyadmin clone database)

Open PHPRunner and go to the Tables (Datasource tables) tab and right-click on your database.

Click on properties and you can then find your new database in the drop down list.
Admin 2/22/2015

Proceed to 'Datasource tables' screen, locate your table on the diagram and click context menu icon (dot) near its name or right-click it. Change caption option allows to edit caption and field labels. Click 'Advanced...' option to change a base table (is available only for view/chart/report) or filename prefix.
B
 		bcritchley author 2/23/2015



Hi,

Clone your database to the new name using PHPMyadmin (Search Google for phpmyadmin clone database)

Open PHPRunner and go to the Tables (Datasource tables) tab and right-click on your database.

Click on properties and you can then find your new database in the drop down list.


So if I understand correctly, I can use MSSQL to backup and restore the original database to the name I want and then point my original project to the new database. Once i rebuild it will have the new URL that I desire.
P
 		procheck 2/23/2015

Have a look at Sergey's response first. It might be all you need to do.