In pb, the stored process is saved using SQL statements (bringing numbers and returned values)

In Pb, the stored process is saved using SQL statements (bringing numbers and returned values)

/// Declare the stored procedure:
Create procedure proc_pslx (@ name varchar (2), @ count integer output)
As

Select @ COUNT = count (*) from wo_info where whs_name = @ name;

Go

 

// Call in Pb:

Integer li_rtn
Declare lpro_test procedure for proc_pslx @ name = 'c1', @ COUNT =: li_rtn output;

Execute lpro_test;

Fetch lpro_test into: li_rtn;
MessageBox ("", string (li_rtn ))
// When using the stored procedure in Pb, the parameter data must be consistent with that in SQL.