ผมเข้าเมนู ทะเบียนผู้ป่วยยังไม่ชำระเงิน วันที่ 30 กค. 50 แล้วคลิกโอนค่าใช้จ่ายรายนี้ไปที่ทะเบียนค้างชำระ มันมี error ดังนี้ครับ
EurekaLog 6.0.3
Application:
-------------------------------------------------------
1.1 Start Date : Wed, 22 Aug 2007 14:35:34 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.50.7.4
1.4 Parameters :
1.5 Compilation Date: Wed, 4 Jul 2007 18:25:46 +0700
1.6 Up Time : 22 minutes, 22 seconds
Exception:
----------------------------------------------------------------------------------
2.1 Date : Wed, 22 Aug 2007 14:57:56 +0700
2.2 Address : 00417393
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.50.7.4
2.5 Type : EVariantTypeCastError
2.6 Message : Could not convert variant of type (Null) into type (Double).
2.7 ID : 6BDC
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : supervisor
3.2 Name : supervisor
3.3 Email :
3.4 Company :
3.5 Privileges: SeChangeNotifyPrivilege - ON
SeSecurityPrivilege - OFF
SeBackupPrivilege - OFF
SeRestorePrivilege - OFF
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 : COMP11
5.2 Total Memory : 1024 Mb
5.3 Free Memory : 564 Mb
5.4 Total Disk : 65.21 Gb
5.5 Free Disk : 55.46 Gb
5.6 System Up Time: 3 days, 33 minutes, 34 seconds
5.7 Processor : Intel(R) Pentium(R) 4 CPU 1.80GHz
5.8 Display Mode : 1024 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : XGI Volari Family v1.13.04.D (driver 6.14.1.1130 - RAM 128 MB)
5.11 Printer : Canon iP1200 (driver 1.90.2.20)
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.001.014
7.2 Submask : 255.255.255.000
7.3 Gateway : 192.168.001.001
7.4 DNS 1 : 203.113.127.199
7.5 DNS 2 : 203.113.024.199
7.6 DHCP : OFF
Custom Information:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 10872 [รพช. เสิงสาง]
8.2 Database Type : MySQL
8.3 Database Protocol: mysql-4.1
8.4 :
8.5 No 1 : select sum(sum_price) as cc from opitemrece where vn='500730091353' and (finance_number IS NULL or finance_number = '') and paidst in ('01','03')
8.6 No 2 : UNLOCK TABLES
8.7 No 3 : SHOW KEYS FROM hos.serial
แก้ไขอย่างไรดีครับ