ขึ้น error ดังรูปครับ แล้วก็พิมพ์ใบสั่งยา หรือ opdcard ไม่ได้เลย
เป็นกับผู้ป่วยหลายคนเลยครับ 50.9.10 ครับ
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
EurekaLog 6.0.6
Application:
--------------------------------------------------------
1.1 Start Date : Wed, 19 Sep 2007 15:51:06 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.50.9.10
1.4 Parameters :
1.5 Compilation Date: Sun, 9 Sep 2007 21:40:26 +0700
1.6 Up Time : 21 hours, 55 minutes, 18 seconds
Exception:
----------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Thu, 20 Sep 2007 13:46:24 +0700
2.2 Address : 00B62A55
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.50.9.10
2.5 Type : EZSQLException
2.6 Message : SQL Error: Illegal mix of collations (tis620_thai_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='.
2.7 ID : 46C3
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : Administrator
3.2 Name : User
3.3 Email :
3.4 Company :
3.5 Privileges: SeChangeNotifyPrivilege - ON
SeSecurityPrivilege - OFF
SeBackupPrivilege - ON
SeRestorePrivilege - ON
SeSystemtimePrivilege - OFF
SeShutdownPrivilege - OFF
SeRemoteShutdownPrivilege - OFF
SeTakeOwnershipPrivilege - OFF
SeDebugPrivilege - OFF
SeSystemEnvironmentPrivilege - OFF
SeSystemProfilePrivilege - OFF
SeProfileSingleProcessPrivilege - OFF
SeIncreaseBasePriorityPrivilege - OFF
SeLoadDriverPrivilege - ON
SeCreatePagefilePrivilege - OFF
SeIncreaseQuotaPrivilege - OFF
SeUndockPrivilege - ON
SeManageVolumePrivilege - OFF
SeImpersonatePrivilege - ON
SeCreateGlobalPrivilege - ON
Active Controls:
--------------------------------
4.1 Form Class : TMainForm
4.2 Form Text : :: HOSxP ::
4.3 Control Class: TdxDBGrid
4.4 Control Text :
Computer:
---------------------------------------------------------------------------------------
5.1 Name : ADMINISTRATOR
5.2 Total Memory : 511 Mb
5.3 Free Memory : 183 Mb
5.4 Total Disk : 33.89 Gb
5.5 Free Disk : 5.95 Gb
5.6 System Up Time: 2 days, 12 hours, 57 minutes, 1 second
5.7 Processor : Intel(R) Pentium(R) 4 CPU 2.40GHz
5.8 Display Mode : 1024 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : ATI Technologies, Inc. RAGE XL PCI (driver 5.1.2001.0 - RAM 4 MB)
5.11 Printer : HP LaserJet 1020 (driver 6, 0, 3508, 0)
Operating System:
------------------------------------
6.1 Type : Microsoft Windows XP
6.2 Build # : 2600
6.3 Update : Service Pack 2
6.4 Language: Thai
6.5 Charset : 222
Network:
---------------------------------
7.1 IP Address: 192.168.000.004
7.2 Submask : 255.255.255.000
7.3 Gateway : 192.168.000.254
7.4 DNS 1 : 203.146.237.237
7.5 DNS 2 : 203.146.237.222
7.6 DHCP : OFF
Custom Information:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 11448 [รพร. ท่าบ่อ]
8.2 Database Type : MySQL
8.3 Database Protocol: mysql-4.1 [5.1.16-beta
Database hos @ 192.168.0.1]
8.4 :
8.5 No 1 : select o.item_no,concat(s.name,' ',s.strength,' ',s.units) as name ,o.qty,o.paidst,d.shortlist , s.displaycolor ,u.name1,u.name2,u.name3 from opitemrece_arc o left outer join s_drugitems s on s.icode=o.icode left outer join drugusage d on d.drugusage=o.drugusage left outer join sp_use u on u.sp_use = o.sp_use left outer join drugitems i on i.icode=o.icode where o.vn='500828143130' order by o.item_no
8.6 No 2 : select o.item_no,concat(s.name,' ',s.strength,' ',s.units) as name ,o.qty,o.paidst,d.shortlist , s.displaycolor ,u.name1,u.name2,u.name3 from opitemrece o left outer join s_drugitems s on s.icode=o.icode left outer join drugusage d on d.drugusage=o.drugusage left outer join sp_use u on u.sp_use = o.sp_use left outer join drugitems i on i.icode=o.icode where o.vn='500828143130' order by o.item_no