Re: SQL problem

Peter Lancashire <Peter.Lancashire.PL1@bayer.co.uk> offerred: +David Williams wrote: +> But SQLCA.SQLEERD[2] is NOT guaranteed to be set after a select... +Yes, my oversight. Apologies. Must RTFM even more... But the database +knows the information - why won't it tell us? I cannot know FOR SURE how many rows are in the result set until the last row has been fetched. E.g. someone could delete a row that would have been part of your result set when you opened the cursor, but by the time you tried to fetch it it was gone. The #rows it thought it would return would not match what actually was returned. sqlca.sqlerrd[2] IS guaranteed to be set after a select once all the rows have been fetched. Of course,in that case you could junt count the rows yourself. Dave ** Dave Kosenko <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training