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)))
@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)))
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货