Re: question about SET_COUNT

Markboy2 (markboy2@aol.com) wrote: : Is it possible to call SET_COUNT within an INPUT ARRAY statement and : have the current array be affected? Or do you have to exit out of the : INPUT ARRAY statement completely and get back in? My problem is that I am Your second assumption is correct; EXIT INPUT and loop back. : explicitly handling all DELETES and INSERTS by keeping track of how many : rows I have in the array, and redisplaying them when the number of rows : changes. BUT - I am losing data off of the end of the array, past the : point where the original SET_COUNT statement set the boundary. This, as : you might guess, is not good. If you null the rows below the filled-in portion of the array, and use ON KEY to handle inserts/deletes, and don't have BEFORE/AFTER INSERT control blocks, call SET_COUNT() with the maximum size of the array (instead of the filled-in part) and you'll never need to call it again. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.