ADOStoredProc1.execproc; if ADOStoredProc1.parameters.parambyname('RETURN_VALUE').value=0 //成功...
有没有人知道AdoTable1.DeleteRecords怎样用的?给个例子
存储过程中的写法 CREATE PROCEDURE Truck_Update @TruckID Int AS SET NOCOUNT ON DECLARE @CurrentError int BEGIN TRANSACTION ---向 TruckOwners 表更新记录 UPDATE Trucks SET TruckID=@TruckID, WHERE TruckID=@TruckID---[PKID]要更换成本表的主关键字 SELECT @CurrentError = @@Error IF @CurrentError != 0 BEGIN GOTO ERROR_HANDLER END COMMIT TRANSACTION SET NOCOUNT OFF RETURN 0ERROR_HANDLER: ROLLBACK TRANSACTION SET NOCOUNT OFF RETURN @CurrentError GO
在程序中判断ADOStoredProc的返回值,就知道存储过程的结果了
可以给出代码我吗?
if ADOStoredProc1.parameters.parambyname('RETURN_VALUE').value=0
//成功...
CREATE PROCEDURE Truck_Update
@TruckID Int
AS
SET NOCOUNT ON
DECLARE @CurrentError int
BEGIN TRANSACTION
---向 TruckOwners 表更新记录
UPDATE Trucks SET
TruckID=@TruckID,
WHERE TruckID=@TruckID---[PKID]要更换成本表的主关键字
SELECT @CurrentError = @@Error
IF @CurrentError != 0
BEGIN
GOTO ERROR_HANDLER
END
COMMIT TRANSACTION
SET NOCOUNT OFF
RETURN 0ERROR_HANDLER:
ROLLBACK TRANSACTION
SET NOCOUNT OFF
RETURN @CurrentError
GO