Offline Mode เข้าไม่ครบทุกตารางครับ
Master : Notebook Windows 7 HOSxP 3.53.1.14 MySQL 5.1.30
Offline1 : PC Windows XP HOSxP 3.53.1.14 MySQL 5.1.30
Offline2 : PC Windows 7 HOSxP 3.53.1.14,18 MySQL 5.0.45
Offline3 : PC Windows 7 HOSxP_PCU 3.53.1.13 MySQL 5.0.45
ลองสลับ Offine กับ Master แล้วก็ไม่ได้ครับ
หลังจาก Sync เข้า Master โดยใช้ระบบ Offline Mode
- ข้อมูลเข้าในตาราง vn_stat - ovst,opitemrece ไม่พบข้อมูลครับ
นี้ครับ Error
Sync Insert : opitemrece , hos_guid = {A530F0E0-A3A3-4401-8C42-1847BAB2C934}
Table : opitemrece insert Key : {A530F0E0-A3A3-4401-8C42-1847BAB2C934} SQL Error: Unknown column 'A3A3' in 'where clause'
Sync Insert : opitemrece , hos_guid = {8A1F78F0-ED21-4AF7-9845-AD06F19BC59B}
Table : opitemrece insert Key : {8A1F78F0-ED21-4AF7-9845-AD06F19BC59B} SQL Error: Unknown column 'ED21' in 'where clause'
Table : opitemrece update Key : {8A1F78F0-ED21-4AF7-9845-AD06F19BC59B} SQL Error: Unknown column 'ED21' in 'where clause'
Table : opitemrece update Key : {A530F0E0-A3A3-4401-8C42-1847BAB2C934} SQL Error: Unknown column 'A3A3' in 'where clause'
Sync Insert : ovst , hos_guid = {D92EA709-16EE-48DE-806F-0101A2238572}
Table : ovst insert Key : {D92EA709-16EE-48DE-806F-0101A2238572} SQL Error: Unknown column '16EE' in 'where clause'
Sync Insert : opdscreen , hos_guid = {07ACBA0C-3E7D-4E2D-90E6-C6BE962F9734}
Table : opdscreen insert Key : {07ACBA0C-3E7D-4E2D-90E6-C6BE962F9734} SQL Error: 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 'D-4E2D-90E6-C6BE962F9734}' at line 1
Sync Insert : opitemrece , hos_guid = {F11BEC5F-728A-4074-A5EC-03E8D581A294}
Table : opitemrece insert Key : {F11BEC5F-728A-4074-A5EC-03E8D581A294} SQL Error: 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 'D581A294}' at line 1
Sync Insert : opitemrece , hos_guid = {D59B8CAB-C377-4976-90F4-35B109101D89}
Table : opitemrece insert Key : {D59B8CAB-C377-4976-90F4-35B109101D89} SQL Error: Unknown column 'C377' in 'where clause'
Sync Insert : opitemrece , hos_guid = {CC55F427-D513-44EE-90C9-94FC2BB1A664}
Table : opitemrece insert Key : {CC55F427-D513-44EE-90C9-94FC2BB1A664} SQL Error: Unknown column 'D513' in 'where clause'
Sync Insert : opitemrece , hos_guid = {C353EC94-7D36-4449-90C4-9A6FF28B32D7}
Table : opitemrece insert Key : {C353EC94-7D36-4449-90C4-9A6FF28B32D7} SQL Error: Unknown column '7D36' in 'where clause'
Table : patient update Key : {EBA9FBDF-4CDF-11DE-8C3E-7FAFEC9218C2} SQL Error: Unknown column '4CDF' in 'where clause'
Table : opitemrece update Key : {C353EC94-7D36-4449-90C4-9A6FF28B32D7} SQL Error: Unknown column '7D36' in 'where clause'
Table : opitemrece update Key : {CC55F427-D513-44EE-90C9-94FC2BB1A664} SQL Error: Unknown column 'D513' in 'where clause'
Table : opitemrece update Key : {D59B8CAB-C377-4976-90F4-35B109101D89} SQL Error: Unknown column 'C377' in 'where clause'
Table : opitemrece update Key : {F11BEC5F-728A-4074-A5EC-03E8D581A294} SQL Error: 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 'D581A294}' at line 1
หัวข้อ: Offline Mode เข้าไม่ครบทุกตารางครับ (อ่าน 5648 ครั้ง)