Re: Calling Stored Procedures from 4GL

> steve@nezsdc.fujitsu.co.nz (Steve Chell) wrote: > >I've been reading up about stored procedures recently, and can see how > >to use them with SQL. One thing that is not clear, however, is how to > >call them from 4GL programs. Is this possible using 4GL version 4.1x > >in conjunction with a 5.0x engine (Online or SE)? If so how? > > Actually, I've been laboring for quite a while now under the assumption > that it wasn't, but I recently discovered I was wrong. > > All you have to do is prepare and execute the statement. Put the normal > ? parameter place-holders in the statement, and open/fetch the cursor if > there are return values. Works bloody good. Also worth noting that, used in conjunction with the RETURN...WITH RESUME feature of SPL, you can use the cursor in the 4gl prog like any other cursor and return multiple rows from the procedure. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England