Re: call procedure from 4gl

On Tue, 18 Apr 2000, Obnoxio The Clown wrote: > From: "OOO" <O.Kotov@vaz.ru> > > > >How can i call stored procedure from 4gl program. > > LET str = "EXECUTE PROCEDURE x()" > PREPARE xstr FROM str > > EXECUTE xstr > What 'noxio said except if your stored procedure returns anything then you must declare a cursor : DECLARE xstr_cursor CURSOR FOR xstr OPEN xstr_cursor FETCH xstr_cursor INTO tmp_xstr CLOSE xstr_cursor You might want to use FOREACH if your procedure can return more than one row. /J\\ -- Jonathan Stowe <mailto:Jonathan.Stowe@dircon.net> Analyst/Programmer, Direct Connection Connection House, 9 Selsdon Way, Cityharbour, London E14 <http://www.dircon.net>;