2. PHPRunner General questions
  3. Adding fields to a Table
This topic is locked

Adding fields to a Table

 		6/20/2009 5:27:51 PM
PHPRunner General questions
M
 mlapl1 author

Hello
Using PHPRunner5.1, I have been working with a database table containing a certain number of fields - and everything works well.
Now, I want to increase the number of fields in the table - adding more details etc...
I had expected that when I started up PHPRunner it would look at the database tables and include the new fields in the table listing. So it would continue to work correctly with what was already there and let me manipulate the new fields. However, this does NOT happen.
As far as I can tell, the only way to include the new fields is to re-select the existing database. The new fields then appear. HOWEVER the good code that had been generated previously is now broken.
How can I modify/upgrade my tables without having to re-do all the work that had I done? There must surely be an easy way to do this.
Thank you all for your help.

Andrew
J
 		Jepsen 6/20/2009

Once you have made yor new fields in the "Tables" tab you project will appear unchanged. The new fields will not appear in your project.
Go to the "Query" tab and hook of the new fields in the list of fields will appear. None of your previous work will be lost. You will however have to select which fields you whish to appear on the pages and do necessary formatting on the pages where the new fields are inserted.
But your original work are still there.
:-)

Morten
M
 		mlapl1 author 6/21/2009

Thank you very much Morten
Andrew