CREATE PROCEDURE P_AppriseModifyFind
@fldAppriseNOS VARCHAR(50),
@fldJobOrderNOS VARCHAR(50),
@fldModelNOS VARCHAR(50),
@fldCustomerS VARCHAR(50),
@fldDepartmentS VARCHAR(50),
@fldWorkShopS VARCHAR(50),
@fldStartDateS varchar(50),
@fldEndDateS varchar(50)
AS
SELECT        
LTRIM(RTRIM( fldAppriseNOS)) AS  fldAppriseNOS, 
                          LTRIM(RTRIM(fldApprisedateS)) AS fldApprisedateS, 
                          LTRIM(RTRIM(fldWorkShopS)) AS fldWorkShopS, 
                          LTRIM(RTRIM(fldJobOrderNOS)) AS fldJobOrderNOS, 
                          LTRIM(RTRIM(fldModelNOS)) AS fldModelNOS, LTRIM(RTRIM(fldCustomerS)) 
                          AS fldCustomerS, LTRIM(RTRIM(fldStartDateS)) AS fldStartDateS, 
                          LTRIM(RTRIM(fldEndDateS)) AS fldEndDateS, LTRIM(RTRIM(fldQtyI)) AS fldQtyI, 
                          LTRIM(RTRIM(fldShellCorlorS)) AS fldShellCorlorS, 
                          LTRIM(RTRIM(fldShellCorlorNumS)) AS fldShellCorlorNumS, 
                          LTRIM(RTRIM(fldMotherBoardS)) AS fldMotherBoardS, 
                          LTRIM(RTRIM(fldCharacterS)) AS fldCharacterS, 
                          LTRIM(RTRIM(fldPowerLineColorS)) AS fldPowerLineColorS, 
                          LTRIM(RTRIM(fldPowerLineLongS)) AS fldPowerLineLongS, 
                          LTRIM(RTRIM(fldPOS)) AS fldPOS, LTRIM(RTRIM(fldPowerLineSpecS)) 
                          AS fldPowerLineSpecS, LTRIM(RTRIM(fldPowerLineSpecTwoS)) 
                          AS fldPowerLineSpecTwoS, LTRIM(RTRIM(fldPowerLineTemperatureS)) 
                          AS fldPowerLineTemperatureS, LTRIM(RTRIM(fldOutsideSighS)) 
                          AS fldOutsideSighS, LTRIM(RTRIM(fldPackRequestS)) AS fldPackRequestS, 
                          LTRIM(RTRIM(fldBoxSignS)) AS fldBoxSignS, LTRIM(RTRIM(fldReS)) 
                          AS fldReS, LTRIM(RTRIM(fldSendS)) AS fldSendS, 
                          LTRIM(RTRIM(fldSignatoryS)) AS fldSignatoryS, LTRIM(RTRIM(fldCCS)) 
                          AS fldCCS, LTRIM(RTRIM(fldLastUpdateDateS)) AS fldLastUpdateDateS, 
                          LTRIM(RTRIM(fldDepartmentS)) AS fldDepartmentS, fldPlanB AS fldPlanB, 
                          LTRIM(RTRIM(fldStaffS)) AS fldStaffS, fldDateS AS fldDateS, 
                          fldTimeS AS fldTimeSFROM             tblAppriseWHERE  ((@fldAppriseNOS='') OR ((@fldAppriseNOS<>'') AND (LTRIM(RTRIM(fldAppriseNOS))=@fldAppriseNOS))) AND
((@fldModelNOS='') OR ((@fldModelNOS<>'') AND (LTRIM(RTRIM(fldModelNOS))=@fldModelNOS))) AND
((@fldCustomerS='') OR ((@fldCustomerS<>'') AND (LTRIM(RTRIM(fldCustomerS))=@fldCustomerS))) AND
(LTRIM(RTRIM(fldDepartmentS))=@fldDepartmentS) AND
((@fldWorkShopS='') OR ((@fldWorkShopS<>'') AND (LTRIM(RTRIM(fldWorkShopS))=@fldWorkShopS))) AND
((@fldStartDateS='') OR ((@fldStartDateS<>'') AND (LTRIM(RTRIM(fldStartDateS))=@fldStartDateS))) AND
((@fldEndDateS='') OR ((@fldEndDateS<>'') AND (LTRIM(RTRIM(fldEndDateS))=@fldEndDateS)))
通過此存儲過程查詢的記錄是只讀,不能ADOSTOREDPROC.edit後ADOSTOREDPROC.post
為什麼啊?下面的就能夠進行上面操作CREATE PROCEDURE P_AppriseModifyFind
@fldAppriseNOS VARCHAR(50),
@fldJobOrderNOS VARCHAR(50),
@fldModelNOS VARCHAR(50),
@fldCustomerS VARCHAR(50),
@fldDepartmentS VARCHAR(50),
@fldWorkShopS VARCHAR(50),
@fldStartDateS varchar(50),
@fldEndDateS varchar(50)
AS
SELECT        *
FROM             tblAppriseWHERE  ((@fldAppriseNOS='') OR ((@fldAppriseNOS<>'') AND (LTRIM(RTRIM(fldAppriseNOS))=@fldAppriseNOS))) AND
((@fldModelNOS='') OR ((@fldModelNOS<>'') AND (LTRIM(RTRIM(fldModelNOS))=@fldModelNOS))) AND
((@fldCustomerS='') OR ((@fldCustomerS<>'') AND (LTRIM(RTRIM(fldCustomerS))=@fldCustomerS))) AND
(LTRIM(RTRIM(fldDepartmentS))=@fldDepartmentS) AND
((@fldWorkShopS='') OR ((@fldWorkShopS<>'') AND (LTRIM(RTRIM(fldWorkShopS))=@fldWorkShopS))) AND
((@fldStartDateS='') OR ((@fldStartDateS<>'') AND (LTRIM(RTRIM(fldStartDateS))=@fldStartDateS))) AND
((@fldEndDateS='') OR ((@fldEndDateS<>'') AND (LTRIM(RTRIM(fldEndDateS))=@fldEndDateS)))