Re: Result codes in SPL

William Hayman wrote: } Hi } } This has been discussed before, but I can't remember the answer. } } How do I get the number of rows inserted, deleted or updated } by a sql statement within a stored procedure. } } Something like v_no_rows = sqlerrd[3]; } William use -> v_no_rows = dbinfo("sqlca.sqlerrd2") Of course you have to declare v_no_rows in the stored procedure define v_no_rows int; and return the value -> return v_no_rows. John