Re: FW: Informix 4gl question

In article <6899ui$ce8@cssun.mathcs.emory.edu>, "Kirpane, Ravindra" <KirpanRM@Maritz.com> writes >} Let me start with a background. >} Scenario : I've a form called xyz.per generated on table xyz. >} I run this form using sperform. press 'Query' and 'Escape'. >} - To my horror I realize, it's going to retrieve 100000 rows. So >} I decide to press Ctrl-C and smartly enough the query aborts and it >} has >} come up with 500 rows. >} Okay My question, can the above scene/job be simulated in a 4gl >} front-end, i.e. thru 4gl screen If I press Ctrl-C, the program >} should >} interrupt the query and retrieve the part of the data set. >} My email id kirpanrm@maritz.com >} >} >} Have A Good Day >} Ravindra >} 314-827-2027 >} >} Depends which version of 4GL. I believe 4.1 and up allow the following OPTIONS SQL INTERRUPT ON or something similar (I don't have a 4GL manual at home). -- 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