Re: input array with unlimited rows

In article <1995Mar2.003243.13538@scammell.ecos.tne.oz.au>, ars@scammell.ecos.tne.oz.au (Adam Skeggs) says: > >Dear all, > >Although I have worked with 4gl for a number of years I have little >experience with "input array". > >The input array statement assumes that you are working with a limited >number of rows. We are trying to edit a large number of rows and have >run into problems. > >To use input array with an unknown number of rows we have to query some >rows, edit them, commit them and then query a new set etc. >This is a problem as we would like to edit the complete set of rows and >then commit them (or abort) in one fell swoop. > >In this case it is not feasible to define the program array with as many >elements as there are rows in the table. > >Does anyone handle this situation in a "nice" way now? how? > >Many thanks for any suggestions. >========================================================================= >Adam Skeggs >askeggs@scammell.ecos.tne.oz.au >========================================================================= Adam, Are you familiar with C-language linked lists? ESQL/C and linked lists...This is probably the only way you're going to get the "bottomless" array... You would create a linked list of rows-found, mapped to the structure of your table, and page forward/backward accordingly in a browse window, as in FOXPRO et al. The fetch would be based on the window size, a window-page at a time. Editing is another story. Tim ( No I do not have any code -- sorry :-) I used to have some for a window in Xwindows but can't find it anywhere ) \\\\|// (o o) ==============================---o00--(_)--00o---============================ Tim Schaefer tschaefe@gate.net The Computer Business Company, Inc. http://www.gate.net/~tschaefe Coconut Creek, FL, USA DILLIGAF! INX_UTIL Tool Kit Shareware:129.91.131.22 Ub...eh...Now, see, who gets to ask the questions here? --Ross Perot =============================================================================