Informix 4GL arrays
Posted in 1992
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
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