Re: Question: get to next row in INPUT ARRAY
Posted in 1991
Path: emory!sol.ctr.columbia.edu!spool.mu.edu!agate!dog.ee.lbl.gov!nosc!crash!ipars!scotto From: scotto@ipars.cts.com (Scott O'Connell) Newsgroups: comp.databases.informix Message-ID: <1991Dec4.071106.21456@ipars.cts.com> Date: 4 Dec 91 07:11:06 GMT References: <1991Dec2.191316.12675@odin.corp.sgi.com> Organization: Spectrum Data Services, Carlsbad, CA In article <1991Dec2.191316.12675@odin.corp.sgi.com> westover@cim1.asd.sgi.com (Richard Westover) writes: > >Keywords: > >Hi, > >I've looked in the manual and can't get an answer so I hope somebody out >there can help me: > > >I'm using INFOMRIX-4GL version 1.10.03K . > >I have a INPUT ARRAY that has 3 columns like : > > [market_code ] [serial_no ] [ist_num] > [market_code ] [serial_no ] [ist_num] > [market_code ] [serial_no ] [ist_num] > [market_code ] [serial_no ] [ist_num] > [market_code ] [serial_no ] [ist_num] > >What I want to do is > > AFTER FIELD market_code > > IF market_code = current values THEN > > Send the cursor to the NEXT ROW > some command like NEXT FIELD market_code DOWN 1 ROW > is what I'm looking for. > > >So, my general problem is how do I within my INPUT ARRAY command >move the cursor up or down a row (or even multiple rows ). I had to do this once in the past. As I recall I did the following: [market_code] [serial_no] [ist_no] [dummy] (dummy is noentry, autonext) AFTER FIELD market_code IF market_code = current values THEN NEXT FIELD dummy This should do what you want. It's been a while and I can't find the code I wrote. I'm pretty sure this was the solution. -- Scott O'Connell - N6ZEK UUCP: {nosc, ucsd}!crash!ipars!scotto Spectrum Data Services ARPA: crash!ipars!scotto@nosc.mil Carlsbad, CA INET: scotto@ipars.cts.com