ผู้เขียน หัวข้อ: patient was admit (อ่าน 4251 ครั้ง)

ad_y · « **เมื่อ:** กันยายน 15, 2006, 04:14:27 AM »

EurekaLog 5.1.7

Application:
-------------------------------------------------------
1.1 Start Date : Thu, 14 Sep 2006 15:04:08 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 2.49.8.12
1.4 Parameters :
1.5 Compilation Date: Sun, 13 Aug 2006 15:06:18 +0700

Exception:
----------------------------------------------
2.1 Date : Thu, 14 Sep 2006 17:02:07 +0700
2.2 Address: 0101713B
2.3 Module : HOSMy.exe
2.4 Type : Exception
2.5 Message: Patient was admit !!!.

Active Controls:
------------------------------------------
3.1 Form Class : TIPTAdmitRequestForm
3.2 Form Text : IPT Request for Admit
3.3 Control Class: TSeSkinButton
3.4 Control Text :

Computer:
-------------------------------------------------------------
4.1 Name : ACER-20D14ADED3
4.2 User : nun
4.3 Total Memory : 479 Mb
4.4 Free Memory : 127 Mb
4.5 Total Disk : 76.69 Gb
4.6 Free Disk : 69.46 Gb
4.7 System Up Time: 4 days, 5 hours, 51 minutes, 11 seconds
4.8 Processor : Intel(R) Pentium(R) 4 CPU 3.06GHz
4.9 Display Mode : 1024 x 768, 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: 192.168.001.072
6.2 Submask : 255.255.255.000
6.3 Gateway : 192.168.001.001
6.4 DNS 1 : 192.168.001.001
6.5 DNS 2 : 000.000.000.000
6.6 DHCP : OFF

Other Information:
--------------------------------------------------------------------------------------------------------------------------------------------
7.1 : Hospital Code = 10749 [âÃ§¾ÂÒºÒÅ àºµ§]
Database Type = MySQL
Database Protocol = mysql-4.1
Last 3 SQL Statement
.
No 1 = select count(hn) as cc from ipt where hn='0105489' and regdate<='2006-09-14' and ( dchdate>='2006-09-14' or dchstts is null )
.
No 2 = select count(*) as cc from ward where name='ÊÙµÔ-¹ÃÕàÇª¡ÃÃÁ'
.
No 3 = select m.name as code,m.name from ward m where m.name like '%Ê%' order by m.name limit 20
.
Server variable

Call Stack Information:
-------------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
-------------------------------------------------------------------------------------------------------------
| Exception Thread: ID=4040; Priority=0; Class=; [Main] |
|-----------------------------------------------------------------------------------------------------------|
|0101713B|HOSMy.exe |IPTAdmitRequestU.pas|TIPTAdmitRequestForm|SeSkinButton3Click |302[7] |
|00684CDE|HOSMy.exe |se_controls.pas |TSeCustomButton |Click |7927[5] |
|006859BA|HOSMy.exe |se_controls.pas |TSeCustomButton |MouseUp |8253[8] |
|004055E0|HOSMy.exe |dxBar.pas | | |33847[0] |
|77D494DA|USER32.dll | | |GetCapture | |
|006D8A40|HOSMy.exe |ZMWrkr.pas |TZMDataList |Create |347[0] |
|006E0040|HOSMy.exe |ZMWrkr.pas |TZMWorker |WriteSpan |5306[42] |
|77D4EB03|USER32.dll | | |CallNextHookEx | |
|0095FD0D|HOSMy.exe |cxContainer.pas | |ApplicationGetMessageMsgHookProc|6237[13] |
|77D496C2|USER32.dll | | |DispatchMessageA | |
|77D496B8|USER32.dll | | |DispatchMessageA | |
|011A08D8|HOSMy.exe |ERDetailEntryU.pas |TERDetailEntryForm |SeSkinButton5Click |2247[5] |
|00684CDE|HOSMy.exe |se_controls.pas |TSeCustomButton |Click |7927[5] |
|006859BA|HOSMy.exe |se_controls.pas |TSeCustomButton |MouseUp |8253[8] |
|004055E0|HOSMy.exe |dxBar.pas | | |33847[0] |
|7C80A0C7|kernel32.dll| | |WideCharToMultiByte | |
|77D494DA|USER32.dll | | |GetCapture | |
|006D8A40|HOSMy.exe |ZMWrkr.pas |TZMDataList |Create |347[0] |
|006E0040|HOSMy.exe |ZMWrkr.pas |TZMWorker |WriteSpan |5306[42] |
|77D4EB03|USER32.dll | | |CallNextHookEx | |
|0095FD0D|HOSMy.exe |cxContainer.pas | |ApplicationGetMessageMsgHookProc|6237[13] |
|77D496C2|USER32.dll | | |DispatchMessageA | |
|77D496B8|USER32.dll | | |DispatchMessageA | |
|0162C14B|HOSMy.exe |EREntryU.pas |TEREntryForm |dxDBGrid1DblClick |831[37] |
|004055E0|HOSMy.exe |dxBar.pas | | |33847[0] |
|00762621|HOSMy.exe |dxDBGrid.pas |TCustomdxDBGrid |MouseDown |2169[28] |
|004055B0|HOSMy.exe |dxBar.pas | | |33844[0] |
|004055E4|HOSMy.exe |dxBar.pas | | |33848[0] |
|004055E0|HOSMy.exe |dxBar.pas | | |33847[0] |
|7C910A8F|ntdll.dll | | |wcsncpy | |
|77D4EB39|USER32.dll | | |CallNextHookEx | |
|006D8A40|HOSMy.exe |ZMWrkr.pas |TZMDataList |Create |347[0] |
|006E0040|HOSMy.exe |ZMWrkr.pas |TZMWorker |WriteSpan |5306[42] |
|0073A8D2|HOSMy.exe |dxTL.pas |TCustomdxTreeList |WndProc |9603[47] |
|0073A780|HOSMy.exe |dxTL.pas |TCustomdxTreeList |WndProc |9556[0] |
|00762ADD|HOSMy.exe |dxDBGrid.pas |TCustomdxDBGrid |WndProc |2291[32] |
|77D4EB03|USER32.dll | | |CallNextHookEx | |
|0095FD0D|HOSMy.exe |cxContainer.pas | |ApplicationGetMessageMsgHookProc|6237[13] |
|77D60050|USER32.dll | | |GetPropA | |
|77D6001A|USER32.dll | | |GetPropA | |
|77D496C2|USER32.dll | | |DispatchMessageA | |
|77D496B8|USER32.dll | | |DispatchMessageA | |
|7C90E64C|ntdll.dll | | |NtSetInformationThread | |
|-----------------------------------------------------------------------------------------------------------|
| |
| Running Thread: ID=2844; Priority=0; Class=TIdUDPListenerThread |
|-----------------------------------------------------------------------------------------------------------|
|7C90E9BE|ntdll.dll | | |NtWaitForSingleObject | |
|004D8AB3|HOSMy.exe |IdStackWindows.pas |TIdStackWindows |RecvFrom |459[4] |
|00401F7C|HOSMy.exe |ZDbcMetadata.pas | | |3322[0] |
|004021E8|HOSMy.exe |ZDbcMetadata.pas | | |3340[0] |
|004032A9|HOSMy.exe |se_controls.pas | | |41789[0] |
|004041B0|HOSMy.exe |QRExpr.pas | | |4441[0] |
|004D8376|HOSMy.exe |IdStackBSDBase.pas |TIdStackBSDBase |ReceiveFrom |584[1] |
|004E7201|HOSMy.exe |IdUDPServer.pas |TIdUDPListenerThread|Run |312[8] |
|7C9010ED|ntdll.dll | | |RtlLeaveCriticalSection | |
|004E6417|HOSMy.exe |IdThread.pas |TIdThread |Execute |327[30] |
|7C9133CE|ntdll.dll | | |RtlEqualUnicodeString | |
|7C914409|ntdll.dll | | |RtlQueryEnvironmentVariable_U | |
|7C91096D|ntdll.dll | | |RtlReleasePebLock | |
|7C9133CE|ntdll.dll | | |RtlEqualUnicodeString | |
|7C914409|ntdll.dll | | |RtlQueryEnvironmentVariable_U | |
|7C91096D|ntdll.dll | | |RtlReleasePebLock | |
|7C9133CE|ntdll.dll | | |RtlEqualUnicodeString | |
|7C914409|ntdll.dll | | |RtlQueryEnvironmentVariable_U | |
|7C91096D|ntdll.dll | | |RtlReleasePebLock | |
|-----------------------------------------------------------------------------------------------------------|
| Calling Thread: ID=4040; Priority=0; Class=; [Main] |
|-----------------------------------------------------------------------------------------------------------|
|00409E8C|HOSMy.exe |ppIniStorage.pas | | |558[0] |
|004E6764|HOSMy.exe |IdThread.pas |TIdThread |Start |442[10] |
|004E6F0B|HOSMy.exe |IdUDPServer.pas |TIdUDPServer |GetBinding |226[15] |
|004DFF71|HOSMy.exe |IdUDPBase.pas |TIdUDPBase |SetActive |305[4] |
|004DFF4C|HOSMy.exe |IdUDPBase.pas |TIdUDPBase |SetActive |301[0] |
|0173792D|HOSMy.exe |MainU.pas |TMainForm |StartServer |2426[30] |
|01737860|HOSMy.exe |MainU.pas |TMainForm |StartServer |2396[0] |
|0173D4AB|HOSMy.exe |MainU.pas |TMainForm |LoginTimerTimer |4668[1320]|
|004055E0|HOSMy.exe |dxBar.pas | | |33847[0] |
|77D496C2|USER32.dll | | |DispatchMessageA | |
|77D496B8|USER32.dll | | |DispatchMessageA | |
|7C90E64C|ntdll.dll | | |NtSetInformationThread | |
|-----------------------------------------------------------------------------------------------------------|
| |
| Running Thread: ID=1164; Priority=0; Class=TJvBaseThread |
|-----------------------------------------------------------------------------------------------------------|
|7C90E9BE|ntdll.dll | | |NtWaitForSingleObject | |
|7C8025D5|kernel32.dll| | |WaitForSingleObjectEx | |
|7C80A6F9|kernel32.dll| | |CreateEventW | |
|7C802550|kernel32.dll| | |WaitForSingleObjectEx | |
|7C80253D|kernel32.dll| | |WaitForSingleObject | |
|7C802530|kernel32.dll| | |WaitForSingleObject | |
|0053421E|HOSMy.exe |JvThread.pas |TJvThread |Synchronize |507[2] |
|00534200|HOSMy.exe |JvThread.pas |TJvThread |Synchronize |505[0] |
|0176D0C4|HOSMy.exe |MainU.pas |TMainForm |JvThread1Execute |14578[4] |
|005346CA|HOSMy.exe |JvThread.pas |TJvBaseThread |Execute |757[2] |
|-----------------------------------------------------------------------------------------------------------|
| Calling Thread: ID=4040; Priority=0; Class=; [Main] |
|-----------------------------------------------------------------------------------------------------------|
|00409E8C|HOSMy.exe |ppIniStorage.pas | | |558[0] |
|005342D1|HOSMy.exe |JvThread.pas |TJvThread |Execute |542[20] |
|00534228|HOSMy.exe |JvThread.pas |TJvThread |Execute |522[0] |
|01737960|HOSMy.exe |MainU.pas |TMainForm |StartServer |2436[40] |
|01737860|HOSMy.exe |MainU.pas |TMainForm |StartServer |2396[0] |
|0173D4AB|HOSMy.exe |MainU.pas |TMainForm |LoginTimerTimer |4668[1320]|
|004055E0|HOSMy.exe |dxBar.pas | | |33847[0] |
|77D496C2|USER32.dll | | |DispatchMessageA | |
|77D496B8|USER32.dll | | |DispatchMessageA | |
|7C90E64C|ntdll.dll | | |NtSetInformationThread | |
-------------------------------------------------------------------------------------------------------------

Modules Information:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Handle |Name |Description |Version |Size |Modified |Path |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|00330000|ScreenCam.dll | | |441344 |2006-04-14 13:16:36|C:\Program Files\HOSxP |
|00400000|HOSMy.exe | |2.49.8.12 |36691456|2006-08-13 15:06:20|C:\Program Files\HOSxP |
|10000000|libmysql41.dll| | |1056768 |2004-07-12 14:36:18|C:\WINDOWS\system32 |
|20000000|xpsp2res.dll |Service Pack 2 Messages |5.1.2600.2180 |2897920 |2004-08-04 05:00:00|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 05:00:00|C:\Program Files\Common Files\System\ado |
|58D40000|Wship6.dll |IPv6 Helper DLL |5.1.2600.2180 |14336 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|5AD70000|uxtheme.dll |Microsoft UxTheme Library |6.0.2900.2180 |218624 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|5B0A0000|umdmxfrm.dll |Unimodem Tranform Module |5.1.2600.0 |13312 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|5B860000|netapi32.dll |Net Win32 API DLL |5.1.2600.2180 |332288 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|5CD70000|serwvdrv.dll |Unimodem Serial Wave driver |5.1.2600.0 |14848 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|5EDD0000|olepro32.dll | |5.1.2600.2180 |83456 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|629C0000|LPK.DLL |Language Pack |5.1.2600.2180 |22016 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|662B0000|hnetcfg.dll |Home Networking Configuration Manager |5.1.2600.2180 |344064 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|71190000|agentmpx.dll |Microsoft Agent Custom Marshaling Proxy DLL |2.0.0.3422 |49152 |2004-08-04 05:00:00|C:\WINDOWS\msagent |
|711D0000|agentctl.dll |Microsoft Agent Control |2.0.0.3422 |214016 |2004-08-04 05:00:00|C:\WINDOWS\msagent |
|71A50000|mswsock.dll |Microsoft Windows Sockets 2.0 Service Provider |5.1.2600.2180 |245248 |2004-08-04 05:00:00|C:\WINDOWS\System32 |
|71A90000|wshtcpip.dll |Windows Sockets Helper DLL |5.1.2600.2180 |19968 |2004-08-04 05:00:00|C:\WINDOWS\System32 |
|71AA0000|WS2HELP.dll |Windows Socket 2.0 Helper for Windows NT |5.1.2600.2180 |19968 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|71AB0000|WS2_32.dll |Windows Socket 2.0 32-Bit DLL |5.1.2600.2180 |82944 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|71AD0000|wsock32.dll |Windows Socket 32-Bit DLL |5.1.2600.2180 |22528 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|71B20000|mpr.dll |Multiple Provider Router DLL |5.1.2600.2180 |59904 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|72D10000|msacm32.drv |Microsoft Sound Mapper |5.1.2600.0 |20480 |2004-08-04 05: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 05:00:00|C:\WINDOWS\system32 |
|732E0000|RICHED32.DLL |Wrapper Dll for Richedit 1.0 |5.1.2600.0 |3584 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|73B50000|AVIFIL32.DLL |Microsoft AVI File support library |5.1.2600.2180 |84992 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|746C0000|msls31.dll |Microsoft Line Services library file |3.10.349.0 |146432 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|74720000|MSCTF.dll |MSCTF Server DLL |5.1.2600.2180 |294400 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|74D30000|oledlg.dll |Microsoft Windows(TM) OLE 2.0 User Interface Support|5.1.2600.0 |117760 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|74D90000|USP10.dll |Uniscribe Unicode script processor |1.420.2600.2180 |406528 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|74E30000|RICHED20.DLL |Rich Text Edit Control, v3.0 |5.30.23.1221 |431616 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|755C0000|msctfime.ime |Microsoft Text Frame Work Service IME |5.1.2600.2180 |177152 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|75A70000|MSVFW32.dll |Microsoft Video for Windows DLL |5.1.2600.2180 |120832 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|75E90000|SXS.DLL |Fusion 2.5 |5.1.2600.2180 |713216 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76380000|msimg32.dll |GDIEXT Client DLL |5.1.2600.2180 |4608 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76390000|imm32.dll |Windows XP IMM32 API Client DLL |5.1.2600.2180 |110080 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|763B0000|comdlg32.dll |Common Dialogs DLL |6.0.2900.2180 |276992 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|765B0000|MSDART.DLL |Microsoft Data Access - OLE DB Runtime Routines |2.81.1117.0 |151552 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76840000|UNIDRVUI.DLL |UniDriver User Interface |0.3.1296.1 |197120 |2004-08-04 00:56:48|C:\WINDOWS\System32\spool\DRIVERS\W32X86\3 |
|76B20000|ATL.DLL |ATL Module for Windows XP (Unicode) |3.5.2284.0 |58880 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76B40000|winmm.dll |MCI API DLL |5.1.2600.2180 |176128 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76BF0000|psapi.dll |Process Status Helper |5.1.2600.2180 |23040 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76C30000|WINTRUST.dll |Microsoft Trust Verification APIs |5.131.2600.2180 |176640 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76C90000|IMAGEHLP.dll |Windows NT Image Helper |5.1.2600.2180 |144384 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76D60000|iphlpapi.dll |IP Helper API |5.1.2600.2180 |94720 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76F20000|DNSAPI.dll |DNS Client API DLL |5.1.2600.2180 |148480 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76F60000|WLDAP32.dll |Win32 LDAP API DLL |5.1.2600.2180 |172032 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76FB0000|winrnr.dll |LDAP RnR Provider DLL |5.1.2600.2180 |16896 |2004-08-04 05:00:00|C:\WINDOWS\System32 |
|76FC0000|rasadhlp.dll |Remote Access AutoDial Helper |5.1.2600.2180 |8192 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|76FD0000|CLBCATQ.DLL | |2001.12.4414.308|498688 |2005-07-26 11:39:44|C:\WINDOWS\system32 |
|77050000|COMRes.dll | |2001.12.4414.258|792064 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77120000|oleaut32.dll | |5.1.2600.2180 |553472 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|771B0000|wininet.dll |Internet Extensions for Win32 |6.0.2900.2781 |658432 |2005-10-21 10:39:30|C:\WINDOWS\system32 |
|773D0000|comctl32.dll |User Experience Controls Library |6.0.2900.2180 |1050624 |2004-08-04 05:00:00|C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9|
|774E0000|ole32.dll |Microsoft OLE for Windows |5.1.2600.2726 |1285120 |2005-07-26 11:39:48|C:\WINDOWS\system32 |
|778D0000|UNIDRV.DLL |Unidrv Printer Driver |0.3.1296.4 |264704 |2004-08-04 00:56:48|C:\WINDOWS\System32\spool\DRIVERS\W32X86\3 |
|77A80000|CRYPT32.dll |Crypto API32 |5.131.2600.2180 |597504 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77B20000|MSASN1.dll |ASN.1 Runtime APIs |5.1.2600.2180 |57344 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77BD0000|midimap.dll |Microsoft MIDI Mapper |5.1.2600.2180 |18944 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77BE0000|MSACM32.dll |Microsoft ACM Audio Filter |5.1.2600.2180 |71680 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77C00000|version.dll |Version Checking and File Installation Libraries |5.1.2600.2180 |18944 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77C10000|msvcrt.dll |Windows NT CRT DLL |7.0.2600.2180 |343040 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77D40000|USER32.dll |Windows XP USER API Client DLL |5.1.2600.2622 |577024 |2005-03-03 01:09:30|C:\WINDOWS\system32 |
|77DD0000|ADVAPI32.dll |Advanced Windows 32 Base API |5.1.2600.2180 |616960 |2004-08-04 05:00:00|C:\WINDOWS\system32 |
|77E70000|RPCRT4.dll |Remote Procedure Call Runtime

doramon

ช่วยรัน code นี้มาให้ดูด้วยครับว่ามันได้ค่าหรือเปล่า

select count(hn) as cc from ipt where hn='0105489' and regdate<='2006-09-14' and ( dchdate>='2006-09-14' or dchstts is null )

navyNP

รู้สึกว่าจะเป็นชาวต่างชาติถามมานะครับ อ.อ๊อด เหอๆ

ad_y

รันคำสั่งแล้ว ได้ค่าเท่ากับ 1

ผู้เขียน หัวข้อ: patient was admit (อ่าน 4251 ครั้ง)

ad_y

patient was admit

doramon

Re: patient was admit

navyNP

Re: patient was admit

ad_y

Re: patient was admit