2. PHPRunner General questions
  3. [SOLVED]  Database / Project Sync Issue
This topic is locked
[SOLVED]

 Database / Project Sync Issue

 		11/21/2019 2:56:08 PM
PHPRunner General questions
lefty author

When modifying a field in the database from the tables screen and syncing database I am seeing some issues
For Example

Changing a field name from Credit_Limit to credit_limit

or fldemail to Email.
Issue 1. The fields are not changing in the table screen nor in designer. The Old field name is present and/Or it makes it a new field. I have seen both happen.

Issue 2. The Query Screen does not change field to lower or uppercase after sync.
I never had an issue with changing field names before this build. not sure when this changed but it is present now. any advice would be appreciated.

The project is too large to upload to demo account, so looking for advice as to what changed.
Sergey Kornilov admin 11/21/2019

SQL Query is not supposed to change automatically. Proceed to SQL Query screen and either Reset it or edit manually.
lefty author 11/21/2019

I can understand the query screen part, but the fields on the table screen were intermittently not changing after sync. Sometimes change and sometimes not ,

Had to reset query for the tables screen to change Which in turn messed with designer had to re-design pages . I don't recall this happening before.

Anyway had to back out and not save , then change fields back to original naming .then re-open as not to lose all work done on other tables before last save.