Re: SQL Selection Set Questions

Posted in 1997

"Billy Wheeler" — 1 Jan 1997 12:43:13 -0500 — source: Informix-list mailing list archive (1991-1998)

On 31 Dec 96 at 3:27, Larry W. Berman wrote: > After performing a SQL select on a table, I need to then know how to > work with the selection set to: > > 1. Step through each record (row) > 2. Retrieve the value for a specific field in each row > 3. Set the value of a specific field in each row > 4. Run another SQL select with an "order by" parameter against the > first selection set to create a new sorted set. Give us a hint - what tools, engine, OS, versions are applicable? And are you using Informix? :-) -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...