Question on Input Array ..
Posted in 1994
Topics: Stored Procedures & SPL
Hi All, I need to incorporate a special feature in my input array statement : on reaching the last row, I want to display a message 'There are no more rows in the direction you are going'. In the display array statement informix automatically provides this. How to do this in input array statement ? I need this because I want to provide an 'update only' form to the user - where some rows are queried, and the user can update them - but they should not be allowed to go beyond the last row. The way I'm trying to do this is as follows : input array .... on key(down) let arr_pos = arr_curr() if arr_pos > count { I have captured count earlier in my foreach } then error 'There are now more rows bla bla ..' else scroll down by 1 end input This is not exactly working ..dont know why ..maybe it is actually going to the next row, but I have to manually display the row on screen ? By the way, I am displaying only one row on the screen at a time. Any clues anyone ? -- SB PS : In Oracle it was so easy : define key-nxtrec as 'nexrec;if field is null then prvrec;'