calling a stored procedure from i4gl (RDS) (fglpc -V = "Version 7.20.UD2") 
Author Message
 calling a stored procedure from i4gl (RDS) (fglpc -V = "Version 7.20.UD2")

I am trying to call a very rudimentary procedure from an i4gl program
(to figure out "How to do this" . I am not sure of the syntax - can
someone help me?

Here is the 4gl (the with stored procedure below it)
------------------------------------------------------------------------
database procdbs
globals
define
        p_in,p_out smallint

end globals

main
call tst_proc1()
end main

function tst_proc1()
define
        scratch char(100)

let scratch = "execute procedure tst_proc(10)      "
prepare run_proc from scratch
execute run_proc

{This creates an error that too many values are returned, but I don't
know how to tell it to accept the returned value(s)}

end function
------------------------------------------------------------------------
{
create procedure tst_proc (
p_invar smallint ) returning smallint   ;

define m_outvar smallint ;

let m_outvar = p_invar * 10 ;

return m_outvar ;

end procedure ;

Quote:
}

------------------------------------------------------------------------


Fri, 08 Oct 2004 16:30:37 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. calling a stored procedure from i4gl (RDS) (fglpc -V = "Version

2. Memory leak under I4GL RDS 7.20.UD4

3. Identifying a stored procedure "version"

4. Date returns as "Jan 8 20"

5. "maximum of 20 roles enabled exceeded"

6. How to delete a record with the key which contains "%20"(space) in the

7. Error 20 "wrong address" problem

8. Status 20 and "wrong address" problem

9. Calling a procedure in "silent" mode

10. Invalid procedure call or argument "DTSDestination"

11. Run-time error "5": Invalid procedure call

12. max of ("...","...","..")


 
Powered by phpBB® Forum Software