พอดีได้ทดลองใช้ 49.9.7 ในระบบ IPD ลองเข้าไปดู ใบสรุปงบหน้าค่ารักษาพยาบาล พบ error ดังภาพ ไม่ทราบว่าเกิดจากอะไรครับ (update structure แล้ว)
EurekaLog 5.1.8
Application:
-------------------------------------------------------
1.1 Start Date : Sun, 10 Sep 2006 19:59:44 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 2.49.9.7
1.4 Parameters :
1.5 Compilation Date: Thu, 7 Sep 2006 21:34:38 +0700
Exception:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Sun, 10 Sep 2006 20:29:05 +0700
2.2 Address: 005FDE21
2.3 Module : HOSMy.exe
2.4 Type : EZSQLException
2.5 Message: 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 '1' at line 1.
Active Controls:
--------------------------------------------
3.1 Form Class : TReportPrintForm
3.2 Form Text : Prepare to Print Report
3.3 Control Class: TSeSkinButton
3.4 Control Text :
Computer:
-------------------------------------------------------
4.1 Name : ANUKUL
4.2 User : thaitanundr
4.3 Total Memory : 1022 Mb
4.4 Free Memory : 542 Mb
4.5 Total Disk : 58.59 Gb
4.6 Free Disk : 35.52 Gb
4.7 System Up Time: 20 hours, 45 minutes, 36 seconds
4.8 Processor : Intel(R) Pentium(R) 5 CPU 2.66GHz
4.9 Display Mode : 1280 x 1024, 32 bit
Operating System:
------------------------------------
5.1 Type : Microsoft Windows XP
5.2 Build # : 2600
5.3 Update : Service Pack 2
5.4 Language: Thai
Network:
---------------------------------------------------
6.1 IP Address: 000.000.000.000 - 192.168.001.171
6.2 Submask : 000.000.000.000 - 255.255.255.255
6.3 Gateway : 000.000.000.000 - 192.168.001.171
6.4 DNS 1 : 000.000.000.000 - 203.150.218.161
6.5 DNS 2 : 000.000.000.000 - 203.150.215.001
6.6 DHCP : OFF - OFF
Other Information:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7.1 : Hospital Code = 10732 [âç¾ÂÒºÒÅ ÁСÒÃÑ¡Éì]
Database Type = MySQL
Database Protocol = mysql-4.1
Last 3 SQL Statement
.
No 1 = 1
.
No 2 = select * from reporttemplate where name='IN-PATIENT 㺧ºË¹éÒ¤èÒÃÑ¡ÉÒ¾ÂÒºÒÅ'
.
No 3 = insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'ANUKUL','INSERT INTO report_access_log (report_access_id,report_name,loginname,department,access_date_time,successful,finish_date_time) VALUES (266,\'IN-PATIENT 㺧ºË¹éÒ¤èÒÃÑ¡ÉÒ¾ÂÒºÒÅ\',\'anukul\',\'040\',\'2006-09-10 20:29:04\',NULL,NULL)')
Server variable
Call Stack Information:
------------------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
------------------------------------------------------------------------------------------------------------------
| Exception Thread: ID=940; Priority=0; Class=; [Main] |
|----------------------------------------------------------------------------------------------------------------|
|005FDE21|HOSMy.exe|ZDbcMySqlUtils.pas | |CheckMySQLError |363[7] |
|005FDD44|HOSMy.exe|ZDbcMySqlUtils.pas | |CheckMySQLError |356[0] |
|00638996|HOSMy.exe|ZDbcMySqlStatement.pas|TZMySQLStatement |ExecuteUpdate |229[24] |
|005EE926|HOSMy.exe|ZDbcStatement.pas |TZEmulatedPreparedStatement|ExecuteUpdate |1954[1] |
|005EEA52|HOSMy.exe|ZDbcStatement.pas |TZEmulatedPreparedStatement|ExecuteUpdatePrepared |1994[1] |
|0066A263|HOSMy.exe|ZAbstractRODataset.pas|TZAbstractRODataset |ExecSQL |1385[16] |
|0179CB34|HOSMy.exe|MainU.pas |TMainForm |JvInterGetValue |15604[15]|
|007945C7|HOSMy.exe|JvInterpreter.pas |TJvInterpreterExpression |GetValue |5705[13] |
|0078D394|HOSMy.exe|JvInterpreter.pas |TJvInterpreterVarList |GetValue |2560[0] |
|00795128|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |GetValue |5977[5] |
|00794500|HOSMy.exe|JvInterpreter.pas |TJvInterpreterExpression |GetValue |5692[0] |
|0079518D|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |GetValue |5989[17] |
|007950F0|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |GetValue |5972[0] |
|00798D01|HOSMy.exe|JvInterpreter.pas |TJvInterpreterUnit |GetValue |7635[1] |
|00793B9D|HOSMy.exe|JvInterpreter.pas |TJvInterpreterExpression |InternalGetValue |5471[30] |
|00793D4B|HOSMy.exe|JvInterpreter.pas |TJvInterpreterExpression |InternalGetValue |5511[70] |
|00793A40|HOSMy.exe|JvInterpreter.pas |TJvInterpreterExpression |InternalGetValue |5441[0] |
|00795F81|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InterpretIdentifier |6394[8] |
|00795F24|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InterpretIdentifier |6386[0] |
|00795331|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InterpretStatement |6027[6] |
|0079524C|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InterpretStatement |6021[0] |
|007960B1|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InterpretBegin |6430[19] |
|00796000|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InterpretBegin |6411[0] |
|00794FDE|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InFunction |5938[11] |
|00794F8C|HOSMy.exe|JvInterpreter.pas |TJvInterpreterFunction |InFunction |5927[0] |
|00798BD5|HOSMy.exe|JvInterpreter.pas |TJvInterpreterUnit |Run |7598[26] |
|00798AC0|HOSMy.exe|JvInterpreter.pas |TJvInterpreterUnit |Run |7572[0] |
|007994E5|HOSMy.exe|JvInterpreter.pas |TJvInterpreterProgram |Run |7844[4] |
|00F3BF02|HOSMy.exe|ReportPrintU.pas | |PrintReportWithParam |655[108] |
|00F3BB90|HOSMy.exe|ReportPrintU.pas | |PrintReportWithParam |547[0] |
|010EAD7B|HOSMy.exe|DischargeU.pas |TDischargeForm |SeSkinButton2Click |2262[5] |
|0069E6BE|HOSMy.exe|se_controls.pas |TSeCustomButton |Click |7927[5] |
|0069F39A|HOSMy.exe|se_controls.pas |TSeCustomButton |MouseUp |8253[8] |
|00A38BFD|HOSMy.exe|cxContainer.pas | |ApplicationGetMessageMsgHookProc|6237[13] |
------------------------------------------------------------------------------------------------------------------
Modules Information:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Handle |Name |Description |Version |Size |Modified |Path |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|00340000|ScreenCam.dll | | |441344 |2006-04-14 13:16:36|C:\Program Files\HOSxP |
|00400000|HOSMy.exe | |2.49.9.7 |37139456|2006-09-07 21:34:40|C:\Program Files\HOSxP |
|03A90000|mdiui.dll |Microsoft? Document Imaging |0.3.2175.0 |42224 |2004-03-22 15:17:10|C:\WINDOWS\System32\spool\DRIVERS\W32X86\3 |
|051F0000|libmysql41.dll| | |1056768 |2004-07-12 14:36:18|C:\WINDOWS\system32 |
|06690000|mdigraph.dll |Microsoft? Document Imaging |0.3.2175.0 |765680 |2004-03-22 15:17:04|C:\WINDOWS\System32\spool\DRIVERS\W32X86\3 |
|06A50000|msi.dll |Windows Installer |3.1.4000.2435 |2890240 |2006-02-21 23:22:12|C:\WINDOWS\system32 |
|10000000|SXGBSYS.DLL |SXG manager |2.0.0.4 |38912 |1997-10-07 15:48:04|C:\WINDOWS\system32 |
|20000000|xpsp2res.dll |Service Pack 2 Messages |5.1.2600.2180 |2897920 |2004-08-04 06:56:38|C:\WINDOWS\system32 |
|4DAE0000|midas.dll |Borland MIDAS Component Package |7.1.1692.666 |297984 |2004-04-23 21:01:00|C:\WINDOWS\system32 |
|4DE10000|msado15.dll |Microsoft Data Access - ActiveX Data Objects |2.81.1117.0 |536576 |2004-08-04 06:56:44|C:\Program Files\Common Files\System\ado |
|4EC50000|gdiplus.dll |Microsoft GDI+ |5.1.3102.2695 |1712128 |2005-10-16 19:53:24|C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.2600.2695_x-ww_54a6ed4b |
|58D40000|Wship6.dll |IPv6 Helper DLL |5.1.2600.2180 |14336 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|5AD70000|uxtheme.dll |Microsoft UxTheme Library |6.0.2900.2523 |218624 |2005-10-15 15:45:46|C:\WINDOWS\system32 |
|5B0A0000|umdmxfrm.dll |Unimodem Tranform Module |5.1.2600.0 |13312 |2001-08-23 19:00:00|C:\WINDOWS\system32 |
|5B860000|netapi32.dll |Net Win32 API DLL |5.1.2600.2756 |336896 |2006-01-17 03:39:28|C:\WINDOWS\system32 |
|5CD70000|serwvdrv.dll |Unimodem Serial Wave driver |5.1.2600.0 |14848 |2001-08-23 19:00:00|C:\WINDOWS\system32 |
|5EDD0000|olepro32.dll | |5.1.2600.2180 |83456 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|629C0000|LPK.DLL |Language Pack |5.1.2600.2180 |22016 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|662B0000|hnetcfg.dll |Home Networking Configuration Manager |5.1.2600.2180 |344064 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|69F00000|sxgb.dll |User mode driver |2.0.0.7 |81920 |1998-01-27 17:27:06|C:\WINDOWS\system32 |
|71190000|agentmpx.dll |Microsoft Agent Custom Marshaling Proxy DLL |2.0.0.3422 |49152 |2004-08-04 06:56:42|C:\WINDOWS\msagent |
|711D0000|agentctl.dll |Microsoft Agent Control |2.0.0.3422 |214016 |2004-08-04 06:56:42|C:\WINDOWS\msagent |
|71A50000|mswsock.dll |Microsoft Windows Sockets 2.0 Service Provider |5.1.2600.2180 |245248 |2004-08-04 06:56:46|C:\WINDOWS\System32 |
|71A90000|wshtcpip.dll |Windows Sockets Helper DLL |5.1.2600.2180 |19968 |2004-08-04 06:56:48|C:\WINDOWS\System32 |
|71AA0000|WS2HELP.dll |Windows Socket 2.0 Helper for Windows NT |5.1.2600.2180 |19968 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|71AB0000|WS2_32.dll |Windows Socket 2.0 32-Bit DLL |5.1.2600.2180 |82944 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|71AD0000|wsock32.dll |Windows Socket 32-Bit DLL |5.1.2600.2180 |22528 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|71B20000|mpr.dll |Multiple Provider Router DLL |5.1.2600.2180 |59904 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|72D10000|msacm32.drv |Microsoft Sound Mapper |5.1.2600.0 |20480 |2001-08-23 19:00:00|C:\WINDOWS\system32 |
|72D20000|wdmaud.drv |WDM Audio driver mapper |5.1.2600.2180 |23552 |2004-08-04 00:56:58|C:\WINDOWS\system32 |
|73000000|winspool.drv |Windows Spooler Driver |5.1.2600.2180 |146432 |2004-08-04 06:56:58|C:\WINDOWS\system32 |
|732E0000|RICHED32.DLL |Wrapper Dll for Richedit 1.0 |5.1.2600.0 |3584 |2001-08-23 19:00:00|C:\WINDOWS\system32 |
|73B50000|AVIFIL32.DLL |Microsoft AVI File support library |5.1.2600.2180 |84992 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|73F10000|DSOUND.dll |DirectSound |5.3.2600.2180 |367616 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|746C0000|msls31.dll |Microsoft Line Services library file |3.10.349.0 |146432 |2001-08-23 19:00:00|C:\WINDOWS\system32 |
|74720000|MSCTF.dll |MSCTF Server DLL |5.1.2600.2575 |297472 |2005-10-15 18:50:04|C:\WINDOWS\system32 |
|74D30000|oledlg.dll |Microsoft Windows(TM) OLE 2.0 User Interface Support|5.1.2600.0 |117760 |2001-08-23 19:00:00|C:\WINDOWS\system32 |
|74D90000|USP10.dll |Uniscribe Unicode script processor |1.420.2600.2180 |406528 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|74E30000|RICHED20.DLL |Rich Text Edit Control, v3.0 |5.30.23.1221 |431616 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|754D0000|CRYPTUI.dll |Microsoft Trust UI Provider |5.131.2600.2180 |512512 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|75A70000|MSVFW32.dll |Microsoft Video for Windows DLL |5.1.2600.2180 |120832 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|75E90000|SXS.DLL |Fusion 2.5 |5.1.2600.2687 |713216 |2005-11-23 23:41:46|C:\WINDOWS\system32 |
|75F80000|browseui.dll |Shell Browser UI Library |6.0.2900.2802 |1022464 |2006-03-02 14:28:18|C:\WINDOWS\system32 |
|76080000|MSVCP60.dll |Microsoft (R) C++ Runtime Library |6.2.3104.0 |413696 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|76380000|msimg32.dll |GDIEXT Client DLL |5.1.2600.2180 |4608 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|76390000|imm32.dll |Windows XP IMM32 API Client DLL |5.1.2600.2180 |110080 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|763B0000|comdlg32.dll |Common Dialogs DLL |6.0.2900.2180 |276992 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|765B0000|MSDART.DLL |Microsoft Data Access - OLE DB Runtime Routines |2.81.1117.0 |151552 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|76600000|CSCDLL.dll |Offline Network Agent |5.1.2600.2180 |101888 |2004-08-04 06:56:42|C:\WINDOWS\System32 |
|76990000|ntshrui.dll |Shell extensions for sharing |5.1.2600.2180 |143872 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|769C0000|USERENV.dll |Userenv |5.1.2600.2180 |723456 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|76B20000|ATL.DLL |ATL Module for Windows XP (Unicode) |3.5.2284.0 |58880 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|76B40000|winmm.dll |MCI API DLL |5.1.2600.2180 |176128 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|76BF0000|PSAPI.DLL |Process Status Helper |5.1.2600.2180 |23040 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|76C30000|WINTRUST.dll |Microsoft Trust Verification APIs |5.131.2600.2180 |176640 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|76C90000|IMAGEHLP.dll |Windows NT Image Helper |5.1.2600.2180 |144384 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|76D60000|iphlpapi.dll |IP Helper API |5.1.2600.2180 |94720 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|76F20000|DNSAPI.dll |DNS Client API DLL |5.1.2600.2180 |148480 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|76F60000|WLDAP32.dll |Win32 LDAP API DLL |5.1.2600.2180 |172032 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|76FB0000|winrnr.dll |LDAP RnR Provider DLL |5.1.2600.2180 |16896 |2004-08-04 06:56:48|C:\WINDOWS\System32 |
|76FC0000|rasadhlp.dll |Remote Access AutoDial Helper |5.1.2600.2180 |8192 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|76FD0000|CLBCATQ.DLL | |2001.12.4414.310|498688 |2006-02-25 22:27:32|C:\WINDOWS\system32 |
|77050000|COMRes.dll | |2001.12.4414.258|792064 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|77120000|oleaut32.dll | |5.1.2600.2180 |553472 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|771B0000|wininet.dll |Internet Extensions for Win32 |6.0.2900.2781 |661504 |2006-03-02 14:28:28|C:\WINDOWS\system32 |
|773D0000|comctl32.dll |User Experience Controls Library |6.0.2900.2649 |1053696 |2005-10-16 19:55:06|C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2649_x-ww_aac16c8b|
|774E0000|ole32.dll |Microsoft OLE for Windows |5.1.2600.2846 |1286144 |2006-02-25 22:27:38|C:\WINDOWS\system32 |
|77760000|shdocvw.dll |Shell Doc Object and Control Library |6.0.2900.2805 |1495040 |2006-03-02 14:28:26|C:\WINDOWS\system32 |
|77920000|SETUPAPI.dll |Windows Setup API |5.1.2600.2180 |983552 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|77A20000|cscui.dll |Client Side Caching UI |5.1.2600.2180 |326656 |2004-08-04 06:56:42|C:\WINDOWS\System32 |
|77A80000|CRYPT32.dll |Crypto API32 |5.131.2600.2180 |597504 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|77B20000|MSASN1.dll |ASN.1 Runtime APIs |5.1.2600.2180 |57344 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|77B40000|appHelp.dll |Application Compatibility Client Library |5.1.2600.2180 |126976 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|77BD0000|midimap.dll |Microsoft MIDI Mapper |5.1.2600.2180 |18944 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|77BE0000|MSACM32.dll |Microsoft ACM Audio Filter |5.1.2600.2180 |71680 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|77C00000|version.dll |Version Checking and File Installation Libraries |5.1.2600.2180 |18944 |2004-08-04 06:56:48|C:\WINDOWS\system32 |
|77C10000|msvcrt.dll |Windows NT CRT DLL |7.0.2600.2180 |343040 |2004-08-04 06:56:44|C:\WINDOWS\system32 |
|77D40000|USER32.dll |Windows XP USER API Client DLL |5.1.2600.2622 |577024 |2005-10-14 03:36:14|C:\WINDOWS\system32 |
|77DD0000|ADVAPI32.dll |Advanced Windows 32 Base API |5.1.2600.2180 |616960 |2004-08-04 06:56:42|C:\WINDOWS\system32 |
|77E70000|RPCRT4.dll |Remote Procedure Call Runtime |5.1.2600.2810 |582144 |2006-01-17 03:39:34|C:\WINDOWS\system32 |
|77F10000|GDI32.dll |GDI Client DLL |5.1.2600.2818 |280064 |2006-01-17 03:39:16|C:\WINDOWS\system32 |
|77F60000|SHLWAPI.dll |Shell Light-weight Utility Library |6.0.2900.2781 |474112 |2006-03-02 14:28:26|C:\WINDOWS\system32 |
|77FE0000|Secur32.dll |Security Support Provider Interface |5.1.2600.2180 |55808 |2004-08-04 06:56:46|C:\WINDOWS\system32 |
|7C800000|kernel32.dll |Windows NT BASE API Client DLL |5.1.2600.2687 |983552 |2005-11-23 23:41:44|C:\WINDOWS\system32 |
|7C900000|ntdll.dll |NT Layer DLL |5.1.2600.2180 |708096 |2004-08-04 06:56:38|C:\WINDOWS\system32 |
|7C9C0000|shell32.dll |Windows Shell Common Dll |6.0.2900.2781 |8452608 |2006-01-17 03:39:42|C:\WINDOWS\system32 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Registers:
----------
หัวข้อ: ใบสรุปงบหน้า IPD 2.49.9.7 (อ่าน 99980 ครั้ง)