Home > database >  Open the cursor statement behind, and assignment is given no effect!
Open the cursor statement behind, and assignment is given no effect!

Time:04-17

Delphi7 invoke MySql stored procedures, under the open the cursor in the process of storage, give and assign a value to the stored procedure, can not get out the parameter values, as shown below:
Create procedure MyProc (in inpara varchar (20), the out outpara varchar (100))
The begin
.
Declare cur1 cursor for the select id from table1;
The open cur1;
The set outpara='ABC';//as long as in the open cur1; Behind the statement, won't get outpara values, are shown as empty,
.
end;
To solve!

CodePudding user response:

The problem you met, please master pushing!

CodePudding user response:

Don't a person to solve the problem? Are not met?

CodePudding user response:

Who can provide a train of thought, the problem haven't got a clue!
  • Related