3.55.2.10 ห้องการเงินกับการทำค้างชำระ

[golf_win]

พบ error ที่ replicate agent ครับหลังจากห้องการเงินทำค้างชำระผู้ป่วย

17/02/2012 09:43:37 192.168.2.250/hos  #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '550216135512' and income='12'  and  (finance_number is null or finance_number=''' at line 1 CLI>CASH SQL>update opitemrece set finance_number='3032 where vn = '550216135512' and income='12'  and  (finance_number is null or finance_number='')
17/02/2012 09:43:38 192.168.2.248/hos  #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '550216135512' and income='12'  and  (finance_number is null or finance_number=''' at line 1 CLI>CASH SQL>update opitemrece set finance_number='3032 where vn = '550216135512' and income='12'  and  (finance_number is null or finance_number='')

[เกื้อกูล ครับ..]

update opitemrece set finance_number='3032 where vn = '550216135512'

[udomchok]

update opitemrece set finance_number='3032 where vn = '550216135512'

single quote ไม่ครบคู่