2. PHPRunner General questions
  3. [SOLVED]  Project not saving last part of SQL WHERE statement
This topic is locked
[SOLVED]

 Project not saving last part of SQL WHERE statement

 		10/16/2013 8:07:11 AM
PHPRunner General questions
E
 expo101 author

PHPRunner 7.0 Build 18411

My first version 7.0 project does not correctly save the edited sql query. The last AND statement in the WHERE section gets lost after saving and reopening the project.
This is the full WHERE statement:

WHERE (a_master.status <>'niet in feed')

AND (CASE WHEN a_master.m_groepsreis IS NULL THEN a_master.groepsreis=0 ELSE a_master.m_groepsreis=0 END)

AND (CASE WHEN a_master.m_rondreis IS NULL THEN a_master.rondreis=1 ELSE a_master.m_rondreis=1 END)


After saving and reopening the project the statement is missing the last AND section and looks like:

WHERE (a_master.status <>'niet in feed') AND (CASE WHEN a_master.m_groepsreis IS NULL THEN a_master.groepsreis=0 ELSE a_master.m_groepsreis=0 END)


Since the remaining sql query is still a valid query, no error messages or errors occur but the data shown on the webpages is not want was intended to present.

I can't recall I had this situation in version 6.2 and to me it seems a bug in the 7.0 version.
Sergey Kornilov admin 10/16/2013

Contact support at http://support.xlinesoft.com sending your project file along with script that creates required database tables. Someone investigate the issue and be back to you.
E
 		expo101 author 10/17/2013



Contact support at http://support.xlinesoft.com sending your project file along with script that creates required database tables. Someone investigate the issue and be back to you.


Thanks Sergey, I'll contact support asap.