Re: SQL problem

In article <359b6dcb.17859370@nntp.news.netcom.net>, David Kosenko <davek@summitdata.com> writes >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. Whrer does it say that? > >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 -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care