ยังไม่ได้ครับ ถ้าไม่ลงยา บันทึกได้ครับ
date/time : 2014-06-25, 15:59:46, 13ms
computer name : COMP1
user name : Administrator <admin>
registered owner : Sky123.Org / Sky123.Org
operating system : Windows 7 Service Pack 1 build 7601
system language : Thai
system up time : 9 days 7 hours
program up time : 2 minutes 2 seconds
processors : 4x Intel(R) Core(TM) i3-4130 CPU @ 3.40GHz
physical memory : 1198/3539 MB (free/total)
free disk space : (C:) 160.51 GB
display mode : 1024x768, 32 bit
process id : $1e10
allocated memory : 171.42 MB
executable : Turbo_HOSxP_PCU.exe
exec. date/time : 2014-06-23 22:28
version : 3.57.6.23
compiled with : Delphi 2007
madExcept version : 4.0.6
callstack crc : $4092b0ae, $f3b3bda8, $f3b3bda8
exception number : 1
exception class : Exception
exception message : Incorrect number of arguments for FUNCTION hos.get_stock_item_department_remain_qty; expected 3, got 2.
Main ($11e8):
00a92920 +0140 Turbo_HOSxP_PCU.exe ZAbstractRODataset 1672 +36 TZAbstractRODataset.InternalOpen
02d1ba0a +02ae Turbo_HOSxP_PCU.exe HOSxPDMU 12568 +72 HOSxP_GetDataSet
02d1d91b +0057 Turbo_HOSxP_PCU.exe HOSxPDMU 13207 +4 GetSQLData
02cdc2f3 +009b Turbo_HOSxP_PCU.exe RxPayInventoryItemErrorUnit 85 +6 TRxPayInventoryItemErrorForm.ItemCDSBeforePost
02cdc4c4 +00d8 Turbo_HOSxP_PCU.exe RxPayInventoryItemErrorUnit 125 +30 TRxPayInventoryItemErrorForm.SetVN
02ce71bb +0487 Turbo_HOSxP_PCU.exe HOSxPDMU 863 +87 DoConfirmStockOpitemreceItem
01b8cbba +1106 Turbo_HOSxP_PCU.exe OneStopServiceMainU 2064 +230 TOneStopServiceMainForm.DoSaveVisitData
01b8f671 +03a9 Turbo_HOSxP_PCU.exe OneStopServiceMainU 2520 +68 TOneStopServiceMainForm.cxButton2Click
007c1a0b +006f Turbo_HOSxP_PCU.exe cxButtons 1634 +8 TcxCustomButton.Click
007c2119 +002d Turbo_HOSxP_PCU.exe cxButtons 1926 +2 TcxCustomButton.CNCommand
007c208a +007a Turbo_HOSxP_PCU.exe cxButtons 1907 +11 TcxCustomButton.WndProc
02d958ae +0122 Turbo_HOSxP_PCU.exe Turbo_HOSxP_PCU 961 +33 initialization
hardware:
Hospital Code = 02580 [สอ. กุดโบสถ์ บ้านกุดโบสถ์ หมู่ที่ 01]
Database Type = MySQL
Database Protocol = mysql-4.1 [5.5.31-30.3]
Last 3 SQL Statement
No 1 = select get_stock_item_department_remain_qty(91,1) as cc
.
No 2 = select o.hos_guid,o.icode,substring(o.icode,1,1) as scode,o.income,concat(s.name,' ',s.strength,' ',s.units) as name, o.qty, o.unitprice ,sum(sum_price) as totprice , d.drugusage,d.code,d.name1,d.name2,d.name3,d.shortlist,dt.name as doctor_name , k.department as dep_name ,u.name1,u.name2,u.name3,i.name as income_name,st.department_id,st.remain_qty,st.item_id,st.sp_status,st.opi_guid , concat(sm.item_name,' ',sm.item_unit) as inventory_item_name 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 doctor dt on dt.code=o.doctor left outer join kskdepartment k on k.depcode=o.dep_code left outer join sp_use u on u.sp_use = o.sp_use left outer join income i on i.income = o.income left outer join stock_opitemrece st on st.opi_guid = o.hos_guid left outer join stock_item sm on sm.item_id = st.item_id where o.vn='570625100915' and o.hos_guid in ('{A704609B-8C61-4D55-A6AF-BBF20E0A865F}','{BD792983-D135-4CF4-821C-B9993EEEF601}') group by o.hos_guid,o.icode,s.name,s.strength,s.units,o.qty,o.unitprice,d.drugusage,d.code,d.name1,d.name2,d.name3,d.shortlist,dt.name,k.department,u.name1,u.name2,u.name3 order by scode ,o.income,o.item_no,s.name
.
No 3 = select opi_guid from stock_opitemrece where vn ='570625100915' and sp_status='N'
หัวข้อ: hos.get_stock_item_department_remain แก้ไขยังไงครับ (อ่าน 3871 ครั้ง)