Re: SP's and SQLERRD ???

> Within a SP, I want to perform a select. After the select, I want to > determine whether any rows were found. According to TFM, using dbinfo > to get > 'sqlca.sqlerrd2' will return the number of rows processed. Only > problem, it > doesn't return anything near accurate results. FWIW, according to the 4GL manuals: SQLERRD[1] Is not used SQLERRD[2] Is the SERIAL value or ISAM return code SQLERRD[3] Is the number of rows processed SQLERRD[4] Is the ext CPU cost of the query SQLERRD[5] Is the offset of the error into the SQL Statement SQLERRD[6] Is the ROWID of the last row I hope this helps. ------------------------------------------------------------------- These are *my* opinions. Please don't make the mistake of believing anybody else is stupid enough to think like this! ------------------------------------------------------------------- Stuart Hemming | shemminga@cix.compulink.co.uk The Data Base | Tel: + 44 (0) 115 925 0005 Nottingham UK | Fax: + 44 (0) 115 925 0951 -------------------------------------------------------------------