SQL Selection Set Questions

Posted in 1996

Gordon E. Hooker — Mon, 30 Dec 1996 14:18:21 GMT — source: Informix-list mailing list archive (1991-1998)

WebMaster@HyperNetUSA.com (Larry W. Berman) wrote: Using cursors is covered fully in the Informix Documentation >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. > >Thanks for your help. > >Larry Berman _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP 25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555 Email gordonh@thehub.com.au _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year Pink Floyd