Re: Fixes to Informix-4gl

Quoting Stuart Hemming... } } In-Reply-To: <1gor7vINN4u9@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) } } TITLE: Re: Fixes to Informix-4gl } } In <1gor7vINN4u9@emory.mathcs.emory.edu> Dave Snyder writes: } } [Stuff deleted] } } > Sounds great... but what happens if the data isn't sorted alphabetically? } > An example that comes to mind is in a medical system that I just wrote. } > There is a pop-up window of languages that people have to select from. } > In our area, ENGLISH is first, SPANISH is second, FRENCH third, etc. I } > display this by using an internal sequence number assigned by the customer. } > Now although there are only about a dozen or two languages and "page ahead" } > would only have to be hit twice, how would this work if you had many rows? } } I think this one should be looked at more in the principle of the } thing rather than in the execution of the given example. Could it not } be arranged so that the displayed list was indexed on some column and } have the "page ahead" funtion work on that column? } Probably not. The page ahead function works because the data is sorted somehow. If you were to use another column that was sorted for the page ahead to index, you would then have to say, "What was the code for Russian?" Needless to say, the end-user doesn't need anymore codes to memorize; the patient speeks Russian, I want to select Russian! I'm not knocking this routine, it's a wonderful idea and it can be used 90% of the time. I just wanted to point out that there is that 10% :-) DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com