Re: Informix 4GL arrays

Aaron Pelton writes: > > In my quest for the answer to Informix vs Progress I've come across > a particular area, scrolling data on the screen, that Informix doesn't > seem to handle well. > > Given that I have a set of data that may be anywhere from 0 to n records > that I want to place in a scrolling region on the screen, can it be done > without a LOT of code to accomplish this? > > Arrays would solve the problem only I don't know ahead of time how big > it needs to be and it could be greater than several thousand records. (I > know, it's not likely, but Progress seems to do it naturally.....) Trying > it out I came up with just using INPUT, SCROLL and FETCHES. I use the > keyed data from the INPUT for updates so I have to close the cursor and > reopen it and so forth. I'm at 79 lines (w/ bugs still) and counting while > progress seems to be able to do it in about 10 lines. Sort of the reason > why we want to go to a 4gl...... > > Can anyone recommend a direction to look for clues? Is it possible to > fool informix into using a malloc'd array? > > (Note: I admit it, I'm for informix but I have to convince the others of > the team.....) > -- > Aaron Pelton | If it sounds like an opinion, it's probably mine. > aaron@satco.UUCP | Only R. Crusoe could have it all done by Friday > {decvax,uunet}!virgin!satco!aaron