value [Parameter] example

The following statements call a stored procedure that returns an output parameter. The result is displayed in the Script Pad.

d = new Database( )

d.databaseName = "IBLOCAL"

d.active = true

p = new StoredProc( )

p.database = d

p.procedureName = "DEPT_BUDGET"

p.params[ "DNO" ].value = "670" // Set input parameter

p.active = true

? p.params[ "TOT" ].value // Display output