SCROLL statement help
Posted in 1992
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL
I am using INFORMIX 4GL Version 4.00 on a standard engine and am having some problems with a DISPLAY ARRAY. The problem is that the array holds past, present and future data and I would like to position the cursor on the data relevent to the present and then allow the user to scroll up or down as he/she desires. To do this I assumed that I could use the SCROLL command to do this positioning however the manuals I have do not have any examples of how this is achieved, only the command format and a one line description. I used the SCROLL statement in a FOR loop, testing on a date and if the date does not fall with in the current month I would SCROLL up 1. This was done just before the DISPLAY ARRAY but once the array is displayed to the screen it is starting at the first table entry still. In debug mode the FOR seems to be working fine. Could someone out there please point out what I am doing wrong (Its sure to be something obvious like the command not doing what I thought) or provide an example of this commands correct use. Thanks in advance. -- Ian Franklin | imf@datamark.co.nz | +64-4-233-8186 (work) | Datamark Intl Ltd |--------------------------------------------| Wellington | I drink to make other people intresting | New Zealand | - George Jean Nathan |