我建立了一 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

-------------------------------- 給我一個支點，我可以撐起整個地球

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

加入紅色那一行，試試看... ~小弟淺見，參考看看~

------
~小弟淺見，參考看看~

YOU GOT! 我居然忘記可以利用 SET NOCOUNT ON 的方法讓 Microsoft SQL Server 回傳的訊息正常，真是太感謝你了。 -------------------------------- 給我一個支點，我可以撐起整個地球