SQL Selection Set Questions
Date: 1996/12/30
Message-ID: <32c7cef9.726218_at_news.thehub.com.au>#1/1
WebMaster_at_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_at_thehub.com.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
We are just two lost souls living in a fish bowl
Year after year
Pink Floyd Received on Mon Dec 30 1996 - 00:00:00 CET