Ron Swift asked 5 years ago
When attempting to edit/update rows from Postgresql with Phpedit, I am getting an error:
Couldn’t execute query. ERROR: syntax error at or near “=” LINE 1: UPDATE SET “customernumber”=’1001655′,”weekenddate”=’2018-0… ^ – UPDATE SET “customernumber”=’1001655′,”weekenddate”=’2018-04-22 00:00:00′,”latepaydate”=”,”invoicedate”=’2018-04-23 00:00:00′,”invoiceamount”=’150′,”lateinvoicedate”=’2018-05-24 00:00:00′,”lateinvoiceamount”=’160.5′,”po”=” WHERE “invoiceid” IN (‘32779’)
2 Answers
Abu Ghufran Staff answered 5 years ago
I can’t figure whats exactly wrong in this query. Can you run it on DB IDE and tell which part of query is incorrect and correct alternate?
Ronald Swift answered 5 years ago
null value for some datetime fields was causing the error. I have since set that field as not editable and the edit update works.
Thanks
Your Answer
