DATABASE TRIGGER 致使 TADODataSet.Post 錯誤 |
答題得分者是:channel
|
xBug
一般會員 發表:27 回覆:17 積分:8 註冊:2003-06-10 發送簡訊給我 |
我建立了一 TABLE,並撰寫一 TRIGGER 在此 TABLE 上,可是當我利用 TADODataSet.Post 做存檔時,都會出現 Row cannot be located for updating. Some values may have been changed since it was last read. 的錯誤訊息,若是忽略此一錯誤,則 TADODataSet.State 會一直處在 dsInsert 狀態下,此時若以 SELECT 查看資料庫資料時,該筆資料卻已被新增,且 Trigger 也能正常運作。 我猜測這是因為 TADODataSet.Post 後,資料庫也把 TRIGGER 的回應值回傳回來,致使 TADODataSet 物件造成誤判,不知是否有哪位先進遇過這問題,能否提供些想法?
CREATE TABLE [dbo].[INV_UNIT_OF_MEASURE] ( [UOM_CLASS_CODE] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL , [UOM_CODE] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL , [UOM_NAME] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL , [DESCRIPTION] [varchar] (80) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL , [BASE_UOM_FLAG] [bit] NOT NULL , [INACTIVE_DATE] [datetime] NULL , [CREATED_BY] [int] NOT NULL , [CREATED_DATE] [datetime] NOT NULL , [LAST_UPDATE_BY] [int] NULL , [LAST_UPDATE_DATE] [datetime] NULL ) ON [PRIMARY] GO CREATE TRIGGER INV_UNIT_OF_MEASURE_T1 ON INV_UNIT_OF_MEASURE FOR INSERT, UPDATE, DELETE AS DELETE INV_UOM_CONVERSION FROM DELETED A LEFT JOIN INV_UOM_CONVERSION B ON A.UOM_CLASS_CODE = B.UOM_CLASS_CODE AND A.UOM_CODE = B.UOM_CODE AND B.INVENTORY_ITEM_ID = 0 INSERT INTO INV_UOM_CONVERSION( UOM_CLASS_CODE , UOM_CODE , INVENTORY_ITEM_ID , DEFAULT_CONVERSION_FLAG , CONVERSION_RATE , CREATED_BY , CREATED_DATE) SELECT UOM_CLASS_CODE , UOM_CODE , 0 , 1 , 1 , CREATED_BY , CREATED_DATE FROM INSERTED-------------------------------- 給我一個支點,我可以撐起整個地球 |
channel
尊榮會員 發表:67 回覆:707 積分:854 註冊:2002-05-02 發送簡訊給我 |
CREATE TRIGGER INV_UNIT_OF_MEASURE_T1 ON INV_UNIT_OF_MEASURE FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON; DELETE INV_UOM_CONVERSION FROM DELETED A LEFT JOIN INV_UOM_CONVERSION B ON A.UOM_CLASS_CODE = B.UOM_CLASS_CODE AND A.UOM_CODE = B.UOM_CODE AND B.INVENTORY_ITEM_ID = 0 INSERT INTO INV_UOM_CONVERSION( UOM_CLASS_CODE , UOM_CODE , INVENTORY_ITEM_ID , DEFAULT_CONVERSION_FLAG , CONVERSION_RATE , CREATED_BY , CREATED_DATE) SELECT UOM_CLASS_CODE , UOM_CODE , 0 , 1 , 1 , CREATED_BY , CREATED_DATE FROM INSERTED加入紅色那一行,試試看... ~小弟淺見,參考看看~
------
~小弟淺見,參考看看~ |
xBug
一般會員 發表:27 回覆:17 積分:8 註冊:2003-06-10 發送簡訊給我 |
本站聲明 |
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇! |