Bug เล็ก ๆ ของระบบ Inventory ตอนดู Stock Card หน้าจอรายงานสินค้าคงเหลือคลังใหญ่และรายการสินค้า(ในข้อมูลพื้นฐาน) อาจารย์ช่วยดูด้วยครับ
Exception:
--------------------------------------------------------------------------------
2.1 Date : Tue, 27 Dec 2011 08:48:26 +0700
2.2 Address : 009D6989
2.3 Module Name : Turbo_HOSxP_PCU.exe
2.4 Module Version: 3.54.12.26
2.5 Type : EZSQLException
2.6 Message :
SQL Error: Unknown column 'l.total_price' in 'field list'. 2.7 ID : 59B6
2.8 Count : 1
2.9 Status : New
2.10 Note :
Call Stack Information:
------------------------------------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=1180; Priority=0; Class=; [Main] |
|----------------------------------------------------------------------------------------------------------------------------------|
|009D6989|Turbo_HOSxP_PCU.exe|ZDbcMySqlUtils.pas | |CheckMySQLError |363[7] |
|009D68AC|Turbo_HOSxP_PCU.exe|ZDbcMySqlUtils.pas | |CheckMySQLError |356[0] |
|00A11578|Turbo_HOSxP_PCU.exe|ZDbcMySqlStatement.pas |TZMySQLStatement |ExecuteQuery |187[15] |
|009C7425|Turbo_HOSxP_PCU.exe|ZDbcStatement.pas |TZEmulatedPreparedStatement|ExecuteQuery |1941[1] |
|009C7561|Turbo_HOSxP_PCU.exe|ZDbcStatement.pas |TZEmulatedPreparedStatement|ExecuteQueryPrepared |1982[1] |
|00A3D908|Turbo_HOSxP_PCU.exe|ZAbstractRODataset.pas |TZAbstractRODataset |CreateResultSet |1552[27] |
|00A3D764|Turbo_HOSxP_PCU.exe|ZAbstractRODataset.pas |TZAbstractRODataset |CreateResultSet |1525[0] |
|00A428B8|Turbo_HOSxP_PCU.exe|ZAbstractDataset.pas |TZAbstractDataset |CreateResultSet |308[11] |
|00A3D9F9|Turbo_HOSxP_PCU.exe|ZAbstractRODataset.pas |TZAbstractRODataset |InternalOpen |1576[11] |
|01179466|Turbo_HOSxP_PCU.exe|HOSxPDMU.pas | |HOSxP_GetDataSet |11839[57]|
|01179238|Turbo_HOSxP_PCU.exe|HOSxPDMU.pas | |HOSxP_GetDataSet |11782[0] |
|01186DA9|Turbo_HOSxP_PCU.exe|kskdmu.pas | |hosxp_getdataset |474[2] |
|01186D84|Turbo_HOSxP_PCU.exe|kskdmu.pas | |hosxp_getdataset |472[0] |
|0104C906|Turbo_HOSxP_PCU.exe|StockModuleU.pas | |HOSxP_GetDataSet |1245[2] |
|0104C8D4|Turbo_HOSxP_PCU.exe|StockModuleU.pas | |HOSxP_GetDataSet |1243[0] |
|01EF5872|Turbo_HOSxP_PCU.exe|StockCardU.pas |TStockCardForm |ShowStockCard |502[314] |
|01EF3FA8|Turbo_HOSxP_PCU.exe|StockCardU.pas |TStockCardForm |ShowStockCard |188[0] |
|01EF3F9F|Turbo_HOSxP_PCU.exe|StockCardU.pas |TStockCardForm |FormShow |179[1] |
|75FB53F5|USER32.dll | | |IsWindow | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|0060FC18|Turbo_HOSxP_PCU.exe|cxClasses.pas |TcxObjectLinkController |Destroy |1976[3] |
|0060FCD8|Turbo_HOSxP_PCU.exe|cxClasses.pas | |ReleaseObjectLinkControllerRefCount|2016[0] |
|0060FD2F|Turbo_HOSxP_PCU.exe|cxClasses.pas | |cxRemoveObjectLink |2038[4] |
|0060FD1C|Turbo_HOSxP_PCU.exe|cxClasses.pas | |cxRemoveObjectLink |2034[0] |
|0060764B|Turbo_HOSxP_PCU.exe|cxControls.pas |TcxControl |WndProc |3633[39] |
|77787760|ntdll.dll | | |RtlLeaveCriticalSection | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|75FB3654|USER32.dll | | |MonitorFromWindow | |
|75FB366A|USER32.dll | | |MonitorFromWindow | |
|023781DE|Turbo_HOSxP_PCU.exe|StockWareHouseItemListU.pas|TStockWareHouseItemListForm|cxButton2Click |128[11] |
|008E4279|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |Click |1659[8] |
|008E47D0|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |CNCommand |1883[4] |
|77792E7D|ntdll.dll | | |RtlAllocateHeap | |
|77793509|ntdll.dll | | |RtlMultiByteToUnicodeN | |
|77792CE3|ntdll.dll | | |RtlFreeHeap | |
|77792C6A|ntdll.dll | | |RtlFreeHeap | |
|777956E7|ntdll.dll | | |RtlDeleteBoundaryDescriptor | |
|008E474F|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |WndProc |1861[18] |
|77792E7D|ntdll.dll | | |RtlAllocateHeap | |
|77793509|ntdll.dll | | |RtlMultiByteToUnicodeN | |
|77792CE3|ntdll.dll | | |RtlFreeHeap | |
|77792C6A|ntdll.dll | | |RtlFreeHeap | |
|777956E7|ntdll.dll | | |RtlDeleteBoundaryDescriptor | |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|75FB557D|USER32.dll | | |SendMessageW | |
|75FD2BE9|USER32.dll | | |CallWindowProcA | |
|75FD2BD3|USER32.dll | | |CallWindowProcA | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F1115|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemGetMessageHook |106[1] |
|75997EE7|KERNELBASE.dll | | |WideCharToMultiByte | |
|75FA9DC7|USER32.dll | | |GetCapture | |
|759A7328|KERNELBASE.dll | | |GetLocaleInfoA | |
|008E474F|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |WndProc |1861[18] |
|764FC452|kernel32.dll | | |InterlockedDecrement | |
|75FB2E3C|USER32.dll | | |DispatchMessageA | |
|75FB2E32|USER32.dll | | |DispatchMessageA | |
|02473C8B|Turbo_HOSxP_PCU.exe|Turbo_HOSxP_PCU.dpr | | |720[28] |
|764FED6A|kernel32.dll | | |GetDriveTypeW | |
------------------------------------------------------------------------------------------------------------------------------------