| |

VerySource

 Forgot password?
 Register
Search
View: 791|Reply: 3

How to get the return value without the output parameter in delphi, know it!

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-1-26 12:20:01
| Show all posts |Read mode
I saw that our company's software background uses such stored procedures.The only input parameters provided are, but the stored procedure provides return according to the execution situation.I don't know if this way of writing replaces the OUTPUT parameter.
How to call the stored procedure in Delphi, get the return value of return, and do different processing.
create procedure SBP_jx_kpdd
   @gzid char (20), @ djlxbs char (3)
as
/ ************************************************* ************** /
--Procedure topic: Invoice Billing Check to see if there is an order errorID = 2100
/ ************************************************* ************** /
declare @errcode integer
set @ errcode = 2100

declare @return integer / * initialization of return results * /
set @ return = 0
 ...
 ...
return = @ return
Reply

Use magic Report

0

Threads

6

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 Poland

Post time: 2020-2-17 15:45:01
| Show all posts
Params ['@ RESULT']
Reply

Use magic Report

0

Threads

6

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

Post time: 2020-2-17 17:00:02
| Show all posts
Params ['@ RETURN']
Reply

Use magic Report

0

Threads

6

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

Post time: 2020-2-18 00:00:01
| Show all posts
Is this Params ['RETURN_VALUE']
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list