2. PHPRunner General questions
  3. Edit page
This topic is locked

Edit page

 		10/10/2009 5:07:50 PM
PHPRunner General questions
F
 fpilot author

I have a table where my listview sql is:

"SELECT

payroll_time.id,

payroll_time.EmpId,

payroll_time.Name,

payroll_time.Date,

payroll_time.Job,

payroll_time.TotalHrs,

payroll_time.Remarks,

payroll_time.Paid,

payroll_time.EndDate,

payroll_time.TotalHrs-(payroll_time.TotalHrs.125) AS After Break,

users.Wage((payroll_time.TotalHrs)-(payroll_time.TotalHrs.125)) AS TotalWage

FROM payroll_time

INNER JOIN users ON payroll_time.EmpId = users.id

ORDER BY payroll_time.Date DESC"
Everything is fine except when I edit the record it gives error as follows:
<<< 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 '((payroll_time.TotalHrs)-(payroll_time.TotalHrs*.125))=102.375 where payroll_ti' at line 1
Pls help.
D
 		danaci 10/11/2009

..

..

FROM payroll_time,users

..

..
J
 		Jane 10/12/2009

Hi,
to update calculated or joined fields use Before record added/Before record updated events on the Events tab.

Here is a sample:

http://www.xlinesoft.com/phprunner/docs/update_multiple_tables.htm