2. PHPRunner General questions
  3. [SOLVED]  Syntax error in View using phprunner
This topic is locked
[SOLVED]

 Syntax error in View using phprunner

 		7/12/2011 3:59:55 PM
PHPRunner General questions
A
 ant author

I am getting problems when I try to do a inline edit to a view which has calculated fields;
Record was NOT edited. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-Hotel Invoice=null where leads.ID=1701' at line 1
I am not sure if this is possible to edit a record which has a calculated view?
C
 		cgphp 7/12/2011

It's hard to tell what exactly might be wrong. For more info about calculated fields, check this page: http://xlinesoft.com/articles/how_to_use_calculated_fields.htm
A
 		ant author 7/12/2011

Thank you very much cgphp for the helpful advice. I figured out that I had the edit inline field checked for the calculated fields, this was initially causing the error. I still got errors and it turned out that I also had the linked table fields checked as edit. When I unchecked the linked table fields and calculated fields it worked.
Is it not possible to link to tables together and edit the fields together instead of opening a separate linked table to edit the fieds from another table ?
Once again thanks for the prompt reply <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=59422&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
C
 		cgphp 7/12/2011



Is it not possible to link to tables together and edit the fields together instead of opening a separate linked table to edit the fieds from another table ?
Once again thanks for the prompt reply <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=59423&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />


The only way to link two tables is by joining them in a custom view.