Re: Stored procedures from 4gl?

rromero@academ01.mty.itesm.mx (Ricardo Javier Romero Elizondo) writes: >I am currently trying to see if I an execute stored procedures from 4gl. After >creating the procedure using DB-Access, I am currently trying to see if I can >execute that procedure from 4gl. >I got as far as a prepare statement and it DOES execute said procedure, but I >still don't know how to handle the returning values that the procedure returns. >Can anyone PLEASE shed some light in the subject? You need to declare a cursor to execute the prepared statment which executes the procedure, then open it, and fetch the returned rows, just like you would if you were fetching from a select cursor. If the procedure returns more than one row, you must RETURN WITH RESUME from the procedure. ___ ___ Senior Consultant / ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210 _/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111 {uunet|pyramid}!infmx!dberg #include <disclaimer.h>